Thread: Macro code
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
NoodNutt NoodNutt is offline
external usenet poster
 
Posts: 221
Default 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.