Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Is there a manageable method to apply on a Protected & Shared Excel Workbook, that when it is opened, Excel just makes visible the worksheet(s) and/or ranges that the user was given permissions/enabled to edit/modify?

My goal is to maintain far away a complex Macro.

share|improve this question
1  
Have you looked into the 'scrollarea' attribute in VBA. You could set a private sub or function that sets the scroll area to what you want. Similar to this thread but with updated language Here is some good info as well. What version of excel are you/they on? Also some more concrete details of what you have vs what you want would help us give specific directions to accomplish your goal –  Raystafarian Mar 1 '12 at 11:45
    
Raystafarian is right. Yet, I don't know if you can hide the worksheet(s) where user cannot write without VBA. Simply ask if you need this. –  JMax Mar 1 '12 at 14:06
    
Will different users have different permissions? The fact that you have shared the workbook will create problems. For example, you cannot change protection levels on a shared workbook. –  mischab1 Mar 2 '12 at 0:32

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.