Hi guys,

Im working on a spreadsheet and would like to make sure that when a
viewer opens the spreadsheet the toolbars(the save and open icons etc
etc) on the top of the screen are removed. However, I would like to
return the users choices of toolbars back once they close the
spreadsheet.

I have been looking at envoking a macro on open and close of
spreadsheet but this still does not help me detect which toolbars the
user has selected... below is some test code of a lil something i tried
(didnt work though!)

' TEST Macro
' Macro recorded 14/02/2006 by x

If (Application.CommandBars("Standard").Visible = False) Then
Range("A20").Select
ActiveCell.FormulaR1C1 = "1"
Range("A21").Select
If (Application.CommandBars("Standard").Visible = True) Then
Range("A21").Select
ActiveCell.FormulaR1C1 = "0"
Range("A21").Select
End Sub

thanks in advance for any help :)


--
Jags
------------------------------------------------------------------------
Jags's Profile: http://www.excelforum.com/member.php...o&userid=31527
View this thread: http://www.excelforum.com/showthread...hreadid=512191