toolbar & view settings

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can you force a specific settings for one specific workbook. For example, I would like with the file val.xls that when anyone on any computer open this file the following happens

force the screen with the view: no sheet tabs, no formula bar, no column and row and on exit to reset to previous view but on exit only

In addition, I would like to force a customize toolbar to display and remove the regular one

Then I want to put a password to open the macro.

Thank you very much for your help on this.
 
I'd suggest asking this in one of the many newsgroups related to Excel (they
all start microsoft.public.excel).

This newsgroup is for questions about Access, the database product that's
part of Office Professional.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


roy said:
How can you force a specific settings for one specific workbook. For
Click to expand...
example, I would like with the file val.xls that when anyone on any computer
open this file the following happens:
force the screen with the view: no sheet tabs, no formula bar, no column
Click to expand...
and row and on exit to reset to previous view but on exit only.
 
Back
Top