Macro Buttons

[SAS]

I've placed a toggle button on a spreadsheet to hide / unhide data. The idea is to show the data to copy and paste results in and give the option to hide the unneeded parts before printing.

Is there anyway to ensure upon loading the spreadsheet the button will default to the unhide position? :/

 

[Gat_Decor]

Private Sub Worksheet_Activate()
ToggleButton1.Value = False

End Sub

all depends how you've coded the togglebutton i.e. if its state is false then the data is unhidden

 

[Gat_Decor]

Actually, looking at it again what i posted was bollox it doesn't work..
i'm stumped, maybe teh excel Meister Joooopitus has an idea?

 

[JingleBells]

Try:

Private Sub CommandButton1_Click()
Rows("10:15").Select
Selection.EntireRow.Hidden = Not Selection.EntireRow.Hidden
End Sub

for the click event on the button.

 

[SAS]

No joy

Spreadsheet is here: (http://www.grenney.co.uk/files/macro April - Bonus Calculator v2 - Team Performance.xls) (to unlock, password is birdflu).

Everything looks logical. Button code works ok, but if I change any statments the columns are always hidden if the "hide" option was selected when the worksheet was closed. Can't seem to force it to be unhid when the worksheet is opened :/

I'm probably missing something obvious mind as I'm a newbie to marcos.

Jup suggested the Workbook_open() option which I've added but does not seem to run. :/

 

[Gat_Decor]

This is what i had in mine to try and get round the 'hidden' becoming 'unhidden' but as i said earlier and you've now tested as Jupitus suggested, it doesn't work.

Private Sub Workbook_Open()
   Columns("H:I").Select   <----- my test columns
    Selection.EntireColumn.Hidden = False

End Sub

 

[MYstIC G]

Sub Workbook_Open()

    Columns("A:IV").Hidden = False

End Sub

Obviously you can change the columns to selected ones if you prefer.

http://support.microsoft.com/?kbid=265113 for more info on WorkBook_Open

You need to set ya Macro security level to Medium really as well.

 

[SAS]

Cheers guys will try the code you pasted when I get some free time.

 

[Rubric]

I'm useless with code but i guess the problem stems from closing the worksheet and it being saved with everything exposed.

If the columns only need revealing when printing why not create a print button and record a macro the unhides the colums prints the document and then hides them again?

Or have a close macro button that ensures that the columns are hidden before exiting and saving.