I need to stop a Macro running in Excel.
Sounds easy, tried the shift key disable and that does not work.
Anyone idea’s!!
Reduce the security clearance of Excel so macros wont run? :shrug:
Go into VBS and delete the macro. (Tools - Macro - Visual Basic Editor)
If it’s a password protected workbook, then Drezha’s way is another solution, but the workbook may not function correctly as links between pages are probably macro driven and of course won’t function.
Thanks folks but I did not fully explain my problem.
Once open, it has a feature that remove the normal selections from the menus, in fact they dissapear.
But I have found out it does use Visual Basic and know the password, so suppose my last question is, do I need to install Visual Basic on my machine in order to get into this spreadsheet?
It should be there already. Look under Tools-Macros and if you have the option Visual Basic Editor you’re sorted.
If by selections you mean the scrollbars, etc, if you can see the menu bar (File, Edit View, etc), go to Tools - Options and from the View tab, tick the Window options you’re missing.
It was quite well protected, now all I need is someone who is good at VB??
What is it your trying to do? In VB Editor you should be able to simply copy the code out of it, and place into a text doc (WordPad), and save and the delete the code which will return the spreadsheet to normal out of box. Now if you have code in the Excel file that is running VB code to calc or related then you’ll need to get someone to tweak the issue code out of the file. For menu item … look for lines with .SHOW = False and simply change those to .SHOW = True …
and yes I think DoubleTop, I and a few others are VB geeks…but don’t tell anyone…LOL!
ALT F11 to get to the Vb editor