Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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

You must log in to answer this question.

Browse other questions tagged .