Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I have 2 questions 1) I need help writing code wihin excel. I want to write code that everytime I open the spreadsheet it takes me to the current date. For example I have a workbook that I create every month that has multiple sheets in it. Each sheet has the days of the month numbered as follows 1, 2,3,4,5 etc. I want the sheet to open to the current day when it opens. Example. if today is the 26th I want the sheet named 26 to be opened first. Excel by default will open to the last sheet that was changed when the save was made. Please help. 2) Also, I would like to know how to hide a sheet within excel using macros. The workbook has multiple sheets in it and I need a specific sheet to always be hidden unless a specific user opens the workbook. For example: if I open the workbook I want to be able to see the sheet, but if another user opens the workbook the sheet will be hidden but all other sheets will be visible. I'm not sure if it matters or not but I need to give access to 4 users to be able to see this sheet but all other users that open the workbook wont be able to see it. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
Convert a Number Code to a Text Code | Excel Discussion (Misc queries) | |||
Unprotect Code Module in Code | Excel Discussion (Misc queries) | |||
copying vba code to a standard code module | Excel Discussion (Misc queries) |