Some of us can run macros fine, but others can not...
Hi all,
Does anyone know why some of our users can run Macros, but others can not? They enable content, and open the .xlsm from the same place as us, but they get the run time errors as seen in the attachments. For other users it works fine... Very random.
Error.JPG
Thanks guys,
Ben
Please post the VBA code - it's unlikely to be random, but unless we know what's in the code and at which point it is causing the error, we can't begin to help.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Hi,
I tried to attach the xlsm but it wouldnt let me. Ill paste the code below instead.
Cheers!
Please Login or Register to view this content.
Last edited by AliGW; 07-07-2020 at 06:44 AM.
Is your code being called automatically when the workbook opens?
Everyone who confuses correlation and causation ends up dead.
Administrative Note:
We would very much like to help you with your query, however you need to include code tags around your code.
Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.
Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(Note: this change is not optional. As you are new, I have done it for you today.)
No it is launched when clicking a button with the macro assigned.
This is the bit highlighted when clicking debug.
Attachment 685626
Last edited by BB1988; 07-07-2020 at 06:50 AM.
Thank you - I will remember for next time.
Your attachment doesn't work, by the way. Which line is highlighted?
Attachment 685633
Does this one work?
Are you all using the same version of excel?
The online help suggests the replace method uses these arguments
expression.Replace (What, Replacement, LookAt, SearchOrder, MatchCase, MatchByte, SearchFormat, ReplaceFormat)
The object browser in O365 returns
Function Replace(What, Replacement, [LookAt], [SearchOrder], [MatchCase], [MatchByte], [SearchFormat], [ReplaceFormat], [FormulaVersion]) As Boolean
FormulaVersion appears to be a new argument.
Yes we are using the same version of Excel.
The post a workbook, currently none of you links are working.
There is a big yellow banner at the top of the page with instructions on how to post workbook
Strange. I can click on the links and they open up the images.
I have tried to follow the instructions in the yellow banner but it says upload of file failed. I have shared a sample of the file on oneDrive but I cant post links as I am new. FML.
Really appreciate any help you can give.
Can you just tell us which line is highlighted by the debugger?
Yes it is line 17 to line 20 all highlighted yellow.
Since there aren't any line numbers in your code, could you just paste the line here?
Sure it is:
Please Login or Register to view this content.
Try removing the part in redPlease Login or Register to view this content.
Many thanks Fluff13 this has solved the issue
Thanks also to rorya for help and persistence
Glad we could help & thanks for the feedback.
For reference, whilst you may all be using 365, you don't all have the same update version.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks