Hey,
I'm developing av calculation-program for for my company who sells electrical services.
The basic is that we export pricefiles to a excel-file, and imports it to the calculation-program.
We want to use this calculation-programme for our workers to make prices for our costumers.
I've made pivottable with a button to refresh the table with and the table refreshes automatically when the sheet is opened.
The next problem i have is that i want to lock the sheet so my co-workers don't mess up my formulas.
The problem is that when i lock the sheet my pivottable won't update.
I want to unlock the sheet when i click the button "refresh" and then lock it again automatically.
Can someone help me with a formula for this?
I've found some formulas for this on the internett, but i can't get them working.
I'm pretty new to macros and formulas so i'm not very good at it yet.
Hope to get some answers.
Best regards Frank from Norway.
Bookmarks