We are using a spreadsheet supplied by head office to process orders. The first worksheet has a number of buttons on it, that when clicked run macro sub routines. This was last used about 10 days ago but 2 days ago when it was used none of the buttons were active. The cursor was displayed as a white cross not as an arrow and placing over a button and clicking does nothing.
I have a copy of the spreadsheet on a memory stick and placing that in another machine it works, but using that copy in the main computer and the same problem occurs. From this I assume the problem is not with the macros (these have worked for years) but either with Windows7 or an Excel setting (Excel 2010). I have set the macro protection to the lowest level and also set the folder the spreadsheet resides in as a safe site to load from.
I'm now at the end of my knowledge, anyone have any ideas?
Bookmarks