how do we achive the default view settings?

J

J_J

Hi,
I know this is simple but... Somehow I managed to change the default view
settings of my worksheets. Now when I right click on sheets tabs I see that
View Code option is inactive. How can I make it active by default as before?
Thanks
J_J
 
T

Tom Ogilvy

in the immediate window do

commandbars("Cell").Reset

or do it in a macro

Sub SetBar()
commandbars("Cell").Reset
End Sub

This assumes you haven't done something that causes excel to disable the
choice because the code module is inaccessible in that context.
 
T

Tom Ogilvy

Sorry, went braindead for a minute
Cell should be PLY

in the immediate window do

commandbars("Ply").Reset

or do it in a macro

Sub SetBar()
commandbars("Ply").Reset
End Sub
 
J

J_J

Tom you are great.
Thank you so much.
J_J

Tom Ogilvy said:
Sorry, went braindead for a minute
Cell should be PLY

in the immediate window do

commandbars("Ply").Reset

or do it in a macro

Sub SetBar()
commandbars("Ply").Reset
End Sub
Click to expand...
 
Top