Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-09-2021, 04:23 PM
Marcia's Avatar
Marcia Marcia is offline Run macro in shared workbook Windows 10 Run macro in shared workbook Office 2019
Expert
Run macro in shared workbook
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default 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.
Attached Files
File Type: xlsm Shared Macro Workbook.xlsm (19.5 KB, 8 views)
Reply With Quote
  #2  
Old 10-01-2021, 05:48 AM
BobBridges's Avatar
BobBridges BobBridges is offline Run macro in shared workbook Windows 7 64bit Run macro in shared workbook Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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.
Reply With Quote
  #3  
Old 10-02-2021, 04:12 PM
Marcia's Avatar
Marcia Marcia is offline Run macro in shared workbook Windows 10 Run macro in shared workbook Office 2019
Expert
Run macro in shared workbook
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Thank you Bob. I do not know what happened but the macro is now perfectly working.
Reply With Quote
  #4  
Old 10-02-2021, 05:05 PM
BobBridges's Avatar
BobBridges BobBridges is offline Run macro in shared workbook Windows 7 64bit Run macro in shared workbook Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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.
Reply With Quote
Reply

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
Run macro in shared workbook Shared Workbook SJT Excel 6 01-12-2012 11:33 AM
Shared Excel workbook eguru2 Excel 0 07-12-2011 12:02 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft