View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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