I would imagine it should be something like ...
![]()
Option Explicit Sub Hide_Window() Application.Visible = False ToggleShow_Hide.Value = True End Sub Sub Show_Window() Application.Visible = True ToggleShow_Hide.Value = False End Sub
I would imagine it should be something like ...
![]()
Option Explicit Sub Hide_Window() Application.Visible = False ToggleShow_Hide.Value = True End Sub Sub Show_Window() Application.Visible = True ToggleShow_Hide.Value = False End Sub
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you again, Trevor
I tried inserting those toggle values in the Show and Hide macros, as you suggested. Then it wanted me to define "ToggleShow_Hide" so I defined it as "ToggleButton" (seemed logical). Like this:
but then it froze up on ToggleShow_Hide.Value, with the following message:![]()
Option Explicit Dim ToggleShow_Hide As ToggleButton Sub Hide_Window() Application.Visible = False ToggleShow_Hide.Value = True End Sub Sub Show_Window() Application.Visible = True ToggleShow_Hide.Value = False End Sub
Attachment 663403. I'm so confused....Am I defining it wrong? Do I need another line to my definitions?
Nick
(I'm only an egg)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks