Hi,
some settings, like visible tool bars, etc. are Excel application specific. Other settings are tied to the workbook. Unfortunately, it is not immediately apparent which settings affect only the current file and which do not.
You would probably need a macro that runs when your form workbook is opened, hides the unwanted toolbars, and another macro that runs before the workbook is closed and restores them again.
This can be achieved by creating two macros in the ThisWorkbook module. Hit Alt-F11, double click ThisWorkbook and enter this code:
To find out what the code is to show and hide your specific taskbars and icons, you can do this:
With the normal toolbars showing, start the macro recorder
hide all the toolbars you want to hide
stop the macro recorder
Then, start the macro recorder again
restore all the toolbars back to normal
stop the macro recorder
Now you have a new code module with the two macros, showing lines similar to these:
for showing toolbars
or
for hiding toolbars and screen elements
Copy and paste these commands into your Workbook_Open and Workbook_BeforeClose routines.
hth
Bookmarks