Thanks Dave work a treat. Any ideas on how I can stop people accessing the
options in a protected worksheet or workbook?
Kind Regards...Mark
"Dave Peterson" wrote:
With a macro, kind of like this...
Option Explicit
sub auto_open()
worksheets("myfavoritesheet").select
end sub
Change the name to match your worksheet.
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Mark_J wrote:
In Microsoft Excel how do you open a workbook to ensure it only opens one a
specified worksheet, no matter what spreadsheet you last saved the workbook
in.
--
Dave Peterson