Macros in shared workbooks

  • Thread starter Thread starter Very Basic User
  • Start date Start date
V

Very Basic User

Hello,

I currently have a shift note file with multiple macros doing things like
making merged cells grow with content, and auto saving to new tabs while
clearning out the master as the sheet is filled in. My problem is that I have
two to three people (Operations, Quality, Safety) that could be filling in
information at any given time during a shift. When I try to share the file,
the macros stop working. Is there any workaround this issue?
 
Macros can run in shared workbooks.

But some features are unavailable in shared workbooks--whether you try to do
them manually or via code.

So the workaround is to not to use those features (or try to find a different
way to do them) or not to share the workbook.

But I think you'll need to share the feature that's not working to get any
specific suggestion (either a workaround or just a "that won't work" response).
 
Generally you can't able to Merge cells in a shared workbook. Open a New
workbook and save it then make the file in sharing mode and see whether you
can able to access the merge cell option? The answer is No.

When we can't able to do it manually then how the macro can merge the cells
when the file is in sharing mode.

If this post helps, Click Yes!
 
By sharing the features, should I just copy and paste the code in a responce
to you?
--
Thank you for your time!
John


Dave Peterson said:
Macros can run in shared workbooks.

But some features are unavailable in shared workbooks--whether you try to do
them manually or via code.

So the workaround is to not to use those features (or try to find a different
way to do them) or not to share the workbook.

But I think you'll need to share the feature that's not working to get any
specific suggestion (either a workaround or just a "that won't work" response).
Click to expand...
 
You could post the entire procedure, but you'll have to indicate what line
fails.

Or you could just determine the line that fails, then look to see what that line
is doing.

For instance, if the failing line is:

worksheets("Sheet999").unprotect password:="hi there"

Then you could look at excel's help for:
"features unavailable in a shared workbook"

And see that changing the protection of a sheet isn't allowed with shared
workbooks. The workaround is to live with the protection (unprotected or
protected) or unshare the workbook.

By sharing the features, should I just copy and paste the code in a responce
to you?
Click to expand...
 
Back
Top