Areti has attended:
Excel VBA Intro Intermediate course
Excel VBA Intermediate course
Macro enabled workbook not working/running macros
I have a file downloaded from the Dept for Education which is macro enabled. In the worksheets there are selection boxes which change the data displayed in the table depending on the selection.
I have enabled content, but the selection list is not working on my PC (works on a colleague's) - the list is static, cannot click into it at all. What could be wrong with my settings to cause this?
Thanks
Areti
RE: macro enabled workbook not working/running macros
Hello Areti,
Thank you for your question. The only thing I can think of is that there might be links in the code to files or directories on another computer. It is hard to tell without seeing the code.
Are you able to run other Excel macros on your machine?
Kind regards
Marius Barnard
Excel Trainer
RE: macro enabled workbook not working/running macros - Resolved
Hi Marius
Thanks for replying. Issue has been resolved now. It appears the problem was with my network profile - the Excel part of it was 2GB and corrupt in some way. Not sure why it why the problem was just this file as I had no problems writing or reading other macros...
regards
Areti
