how do we achive the default view settings?
 

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

how do we achive the default view settings?
 

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.

--
Regards,
Tom Ogilvy


"J_J" wrote in message
...
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

how do we achive the default view settings?
 

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

--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote in message
...
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.

--
Regards,
Tom Ogilvy


"J_J" wrote in message
...
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

how do we achive the default view settings?
 

I think Tom mean "Ply" instead if Cell


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Tom Ogilvy" wrote in message ...
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.

--
Regards,
Tom Ogilvy


"J_J" wrote in message
...
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

how do we achive the default view settings?
 

Tom you are great.
Thank you so much.
J_J

"Tom Ogilvy" wrote in message
...
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

--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote in message
...
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.

--
Regards,
Tom Ogilvy


"J_J" wrote in message
...
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