Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro code
I have created a marco so that i have a button on one page and when you click
on the button it will bring up the document that i have hidden which is correct however i want it to go away once they click on the bottom that says close and i want it to got back to being hidden. How do i do this??? -- Thank you, Brenda |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro code
G'day Brenda
Can you post the code you are using Regards Mark. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro code
here is the code that i used to hide the file;
Sub UnhideExpenseCorpOffice3quarter() Sheets("ExpenseCorpOffice3quarter").Visible = True Sheets("ExpenseCorpOffice3quarter").Select End Sub Now when they click on the button to take them to the file that i have hidden i would like to have a button on that page where if they click the close button it will go back to be hidden. My reason for doing this is because i am creating a spreadsheet for 4 of my reps and i would like for them to be able to hit the button and it wouldn't keep all of the files open. I was also thinking is there a way that they can enter a code and only be able to open up their own spreadsheet i have composed just for them and not to be able to open up the others? -- Thank you, Brenda "NoodNutt" wrote: G'day Brenda Can you post the code you are using Regards Mark. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro code
Deb
On your Sheet "ExpenseCorpOffice3Quarter insert a MacroButton and assign the following. Assign another sheet name where you want the focus to go once the sheet has been hidden. Sub HideExpenseCorpOffice3quarter() Sheets("ExpenseCorpOffice3quarter").Visible = False Sheets("SomeOtherSheetName").Select End Sub HTH Mark. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro code
Ooooppppssss!
Not Deb.....DOH Sorry Brenda...... :-) Mark. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro code to dll and vba code trouble shoot. | Excel Programming | |||
Slow code when used as VBA code instead of macro (copying visible columns) | Excel Programming | |||
Can I use code/macro to change code/macro in an existing file? | Excel Programming | |||
read macro code by vb code | Excel Programming | |||
do anybody have a sample code for executing excel macro from vb code?<eom | Excel Programming |