Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros in shared workbooks
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? -- Thank you for your time! John |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros in shared workbooks
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). Very Basic User wrote: 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? -- Thank you for your time! John -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros in shared workbooks
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! -------------------- (MS-Exl-Learner) -------------------- "Very Basic User" wrote: 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? -- Thank you for your time! John |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros in shared workbooks
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" wrote: 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). Very Basic User wrote: 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? -- Thank you for your time! John -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros in shared workbooks
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. Very Basic User wrote: 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" wrote: 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). Very Basic User wrote: 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? -- Thank you for your time! John -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shared Workbooks-shared headers and footers | New Users to Excel | |||
Shared workbooks | Excel Discussion (Misc queries) | |||
Shared Workbooks | Excel Discussion (Misc queries) | |||
suddenly my excel workbooks are "shared workbooks" | Excel Discussion (Misc queries) | |||
Shared Workbooks | Excel Worksheet Functions |