Dazzybeeguy
Board Regular
- Joined
- Jan 6, 2022
- Messages
- 72
- Office Version
- 365
- 2010
- Platform
- Windows
I have been trying to learn VBA, I have created a couple of Spreadsheets and created some Macros. Everything works fine for me when I access the spredsheets from the folder where others can access them. I emailed the spreadsheets to myself and they don't work on a different PC as it looks for my personal XLSB folder for the code.
So to make all the Macro's work for everyone when they access them from a shared folder, where should I put the code, in a Module or in The "This Workbook" or in each individual Work Sheet it relates to.
I tried to copy and paste the macros from the Personal XLSB but loads of text turned red, is that because it doesn't recognise where it is for.
So to make all the Macro's work for everyone when they access them from a shared folder, where should I put the code, in a Module or in The "This Workbook" or in each individual Work Sheet it relates to.
I tried to copy and paste the macros from the Personal XLSB but loads of text turned red, is that because it doesn't recognise where it is for.
Last edited: