#1
|
||||
|
||||
Run macro in shared workbook
Hi. There is a spellnumber macro in a workbook that stopped working when the workbook was shared. All my search on the problem says that macro should run in a shared workbook but could not be edited, but the spellnumber is showing a #NAME error in the workbook that I shared. Is there a code to add to get the macro running?
Thank you. |
#2
|
||||
|
||||
This is just an educated guess, but is it possible that SpellNumber uses other functions that need to be in your Tools,References list? If so, SpellNumber probably starts to work, but then comes back with that error when it can't find that particular function. Off-hand I don't see such a function in your code, but I didn't look that hard.
|
#3
|
||||
|
||||
Thank you Bob. I do not know what happened but the macro is now perfectly working.
|
#4
|
||||
|
||||
LOL! Don't you hate that? Sure, it works now—but you can't guess when it'll stop working, nor why. Ah, well, some days it's like that.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sync Shared OneNote workbook to Windows 10 | mallycat | OneNote | 0 | 12-10-2018 01:55 PM |
How to make a shared workbook and allow user to edit ranges | prdecina | Excel | 1 | 07-25-2016 11:42 PM |
Excel 2010 - Shared Workbook greyed out | osheac3*40 | Excel | 0 | 03-08-2016 11:40 PM |
Shared Workbook | SJT | Excel | 6 | 01-12-2012 11:33 AM |
Shared Excel workbook | eguru2 | Excel | 0 | 07-12-2011 12:02 AM |