98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Sharing a Workbook with VBA Coding
Sharing a Workbook with VBA Coding
Resolved · High Priority · Version 2003
Fri 10 Oct 2008, 14:49Delegate Dee said...
Dee has attended:
Access Intermediate course
Excel Advanced course
Visio Advanced course
Sharing a Workbook with VBA Coding
WhenI share a workbook that has VBA coding in it, does the VBA code breakdown and not run because the workbook is shared?
As soon as I take the sharing function off the code works perfectly.
Mon 13 Oct 2008, 17:05Trainer Stephen said...
RE: Sharing a Workbook with VBA Coding
Hi Dee
Thank you for your question
Macros should run OK when you share a workbook; but you cannot view or edit the code. Have you also password protected the workbook? If so then this could cause the problem.
If this is not the case or doesn't could you give me some idea what the macro is doing
Regards
Stephne
Tue 14 Oct 2008, 13:50Delegate Dee said...
RE: Sharing a Workbook with VBA Coding
Thanks for your help.
The VBA code called Auto_Open unhides rows then rehides them if certain criteria is met.
This needs to happen as some people will not have finished one of their tasks and it automatically runs forward to the next week. Obviously tasks that have been completed or rows that do not have any tasks, do not need to be in the following week as this will just make the spreadsheet unnecessarily large. Hope that made sense!
The rows that are carried forward need to be password protected to stop people changing the formulas etc but if that is what is causing the problem then I'll have to trust people not to mess with it!
Regards,
Dee
Wed 15 Oct 2008, 10:30Trainer Stephen said...
RE: Sharing a Workbook with VBA Coding
Hi Dee
It is possible to protect a worksheet, whilst still allowing the user to format, in this case hide, columns.
When you protect the worksheet you are given a list of actions that the user can do. If you tick the "format columns " option, then that should allow the macro to hide the required columns.
Without seeing your workbook its difficult to say if this will work. I suggest you give it a try and let me know how it goes
Regards
Stephen
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Moving between split pane sections in a spreadsheetIf you have used the split panes feature in your worksheet, use the following keyboard shortcut keys to move quickly and effortlessly between paned sections: |
