Opening excel workbooks at specific worksheet?

[julescaspar]

Hi-
I am working on a project plan in excel and was wondering if I would be able to have different people open the excel workbook at the specific worksheet that they would need to update? And would I be able to have multiple people updating their worksheets at the same time or does Excel always 'lock' it and give read-only access to the second opener of the workbook?

Also, is there a way to create a 'First page' worksheet that you always open the workbook and it is always the opening page?

Thanks so much!

[Palmetto]

would be able to have different people open the excel workbook at the specific worksheet that they would need to update?

Also, is there a way to create a 'First page' worksheet that you always open the workbook and it is always the opening page?

Which do you want, to open the workbook at a specific sheet for a given user or open to a "first page" sheet? If you're speaking of one workbook then you must choose.

Here is the basic code to get you started. You will need to revise the "Case" statements and sheet references per your users. The last Case statement could be used to go to a "default" sheets if the user name is not among those listed in the case statements.

This code must go into the module named ThisWorkbook. Macro security must be set to Medium and users must choose to enable macros (they refuse and,thereby, defeat the code) when prompted.

Please Login or Register  to view this content.