opening worksheet
If I have a worksheet with multiple sheets, how do I set it to always
open sheet 1 when someone opens the file. Thanks. Bill - new member of the group Boulder, CO |
opening worksheet
hi
a worksheet open event might work. Private Sub Workbook_Open() Sheets("Sheet1").Activate End Sub if you have never worked with macros...see this site... http://www.mvps.org/dmcritchie/excel/getstarted.htm regards FSt1 "maui172" wrote: If I have a worksheet with multiple sheets, how do I set it to always open sheet 1 when someone opens the file. Thanks. Bill - new member of the group Boulder, CO |
All times are GMT +1. The time now is 11:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com