first page upon opening

  • Thread starter Jean-Paul De Winter
  • Start date
J

Jean-Paul De Winter

Hi,
Is there a way to automatically jump to the first page of the worksheet upon
opening the xls file?
Thanks
JP
 
F

Frank Kabel

Hi
put the following code in your workbook module:
sub workbook_open()
me.worksheets(1).activate
end sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top