1 Attachment(s)
Excel problem with (i'm sure) an easy fix.
Attachment 30451
Gent's,
The attached file when opened on most pc's at work operates fine. However on one it doesn't.
On opening the green cells should let you click in them and do certain tasks (the tasks here aren't important). The cross cursor changes to the pointer when moved from other cells to the green ones. However on this one particular PC the cross cursor remains and the green cells are not active.
Any ideas how this is disabled on this particular PC?
Re: Excel problem with (i'm sure) an easy fix.
Sounds like macros are disabled on that pc
Re: Excel problem with (i'm sure) an easy fix.
Not sure what it was but I've had an email to say it's been sorted.
Re: Excel problem with (i'm sure) an easy fix.
I got a script that checks and makes sure they have to enable macros to use a spreadsheet if you want it?
Basically when save the file it hides all the sheets except a warning sheet say macros not turned on. When open sheet if macros on then it unhides the relevant sheets you want and hides the warning one, if they have macros disabled obviously it wont run and all they get is the warning sheet ;-)
Re: Excel problem with (i'm sure) an easy fix.
Thanks akimba but the works system it locked down so couldn't use it
Sent from my LG-H815 using Tapatalk