how do we achive the default view settings?

  • Thread starter Thread starter J_J
  • Start date Start date
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
 
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.
 
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
 
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...
 
Back
Top