Hide File Quick Access Toolbar Close Minimize Maximize buttons by XML Code

[Sarah.M]

Hi, Plz note, My VBA is disabled in my pc, I can use only XML Code, Expression builder, Macros, Queries, Tables, Forms and Reports only.

Kindly I want XML code to hide (File, Customize Quick Access Toolbar , Close, Manimazie, Maximize buttons)
Thanks

[isladogs]

Why / how is VBA disabled in your computer? I didn't think that was possible. Perhaps we can help you fix that?
You can only hide the File menu and QAT if you hide the entire ribbon. You can do that using VBA and Access options but I doubt its possible using XML.
Have a look at my article on Access security in case you are able to implement any of any of the items covered. See Improve Security 2 - Mendip Data Systems

As for the minimize/maximize/close buttons, the easiest method is to hide the entire application window Control Application Interface - Mendip Data Systems but again this requires vba code.
Make sure you have an alternative method of closing your app if you do explore that route e.g. a Quit button

[CJ_London]

@Colin - you might find this link of interest https://support.microsoft.com/en-gb/...a-5983db31823c

Interestingly it says you cannot install MS Access if vba is disabled which is a bit of a paradox since Sarah appears to have Access installed

But would also appear to be an old article since it refers to old versions of access/excel/office so perhaps the situation has changed

@Sarah - agree with Colin, one way or another, you would need to use vba or you might have some luck using C# see this link https://stackoverflow.com/questions/...sizable-window. You might want to talk to your IT dept about enabling VBA on your machine - but that would only be worthwhile if your users also have VBA enabled.

Does sound like safety overkill and perhaps your company should not be using MS office at all. I would imagine sophisticated excel users will be really struggling

[isladogs]

Hi Chris
That's an interesting article
I'd forgotten that VBA is one of the checkboxes that can be disabled during Office installation. Doing that would make Access almost useless even if it can be installed.
If disabled using system policies after installation, that might explain why the OP states they have Access.

However, if its really impossible to use VBA then in my opinion there is little point having the full version of Access at all.
Access runtime would have similar functionality but without the potential issues described in the article.

It sounds like either an installation error or an over-zealous network support person has made a wrong judgement call.

[Sarah.M]

VBA disabled by my company for Security reasons, becuse VBA some people can do bad codes on it

[CJ_London]

they can do bad codes with pretty much any language. At least with vba you are prompted to allow the code to run - unless you are running a very old version of office when such prompts were not available. You are using 2016 - that is why you need to use trusted locations. You might find this link from 7 years ago of interest https://www.howtogeek.com/171993/mac...-be-dangerous/

Usual security rules apply of course - don't open anything you don't trust - and of course use suitable protection from malware such as norton

Good luck with your project but think you will find using macros very limiting.