Custom Views and a Protected sheet

[Cammandk]

I have a Sheet "Cost Man". It has 3 custom views - CostManager1 / Payments1 / Handover1.

I go to the views via macros

When I protect the Sheet "Cost Man" - the macros don't go to the custom view - they go to the basic Sheet "Cost Man".


Is there coding that will allow me to use these other custom views and still be able to protect the main sheet.


Thanks

 

[bobhc]

Good day Cammandk


Macros will not always work with protected work sheets, one way is to use protect and share, the posted link has a lot of information as to get them working other than my suggestion....


http://www.globaliconnect.com/excel/index.php?option=com_content&view=article&id=117:run-vba-macros-on-protected-worksheet-unprotect-a-protect-userinterfaceonly-argument-worksheetprotect-method&catid=79&Itemid=475

 

[Cammandk]

Hi Bob,

Link is interesting. I think I just need a UserInterFaceOnly argument in the one worksheet.

Can you advise if this is correct. The sheet that has the custom views is Sheet4 -(Cost Man).


The Macro below takes me to the Custom View - CostManager1. What and where would the code go.


GoToCostManager1 Macro


Application.ScreenUpdating = False

ActiveWorkbook.CustomViews("CostManager1").Show

Range("E7:E7").Select

Application.ScreenUpdating = True

End Sub