I'm having a strange issue here.
Whenever I protect a worksheet on my desktop, the Select Locked/Unlocked Cells works fine.
However, when I release the Excel to our webserver and download it via the website, it turns off those options and selects other options so I end up not being able to select any cells on the entire worksheet.
Has anyone ever seen this or know how to resolve it?
I've tried using VBA Code and that doesn't fix it either.
Any help is appreciated!
Whenever I protect a worksheet on my desktop, the Select Locked/Unlocked Cells works fine.
However, when I release the Excel to our webserver and download it via the website, it turns off those options and selects other options so I end up not being able to select any cells on the entire worksheet.
Has anyone ever seen this or know how to resolve it?
I've tried using VBA Code and that doesn't fix it either.
Any help is appreciated!