ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hide/Disable Tool bar (https://www.excelbanter.com/excel-programming/352413-hide-disable-tool-bar.html)

ExcelMonkey

Hide/Disable Tool bar
 
How do I hide the tool bar from the user? That is, I do not want the user
to have any access to the Excel tool bar except to close the file.

Thanks

Tom Ogilvy

Hide/Disable Tool bar
 
Loop through the commandbars collection and set the visible property to
false, except for the first two. For those, set the enable property to
false.

--
Regards,
Tom Ogilvy

"ExcelMonkey" wrote in message
...
How do I hide the tool bar from the user? That is, I do not want the

user
to have any access to the Excel tool bar except to close the file.

Thanks





All times are GMT +1. The time now is 07:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com