View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
arunjoshi[_4_] arunjoshi[_4_] is offline
external usenet poster
 
Posts: 1
Default excel - modifying toolbar, keeping it unchnagebale, then re-setting it to original

i want the auto-open macro to make a record of the user's setting of th
toolbar (as to which toolbars have been displayed), and then remove al
toolbars and make them disengaged. i want the user not to be able to g
to ToolsOptions and change the settings there. protecting the workboo
(using a passowrd) does not prevent the user from going t
ToolsOptions.

in the auto-close macro, i want to be able to re-set the toolbars to a
they were originally as per the user's setings.

please help me with a macro code, and explanations in a novice'
language. many thanks

--
Message posted from http://www.ExcelForum.com