Recent content by James2023

No worries I figured it out. Excel when you have cells locked will not allow web link updating unless you unlock the cells and unprotect the sheet. Clearly, this creates an issue if you have a sheet you do not want your end user accessing formulas and processes on, but also requires web...

If I protect the spreadsheet to lock cells and protect the page, will XLS Padlock build in the VBA to allow web updates?

I am having several problems and if anyone can offer advice to resolve them I would be grateful. 1. When sending someone the file by email or even cloud, the file gets rejected and kicked back. 2. I was able to get the file through with Microsoft Cloud One Drive, but Windows has tagged the file...