I'm back again.
I can't quite find the solution to this issue.
I am using saveasUI to disable the save option, but I do have a scenerio where I would like the user to be able to save.
It is all locked down in the code, so the user basically doesn't have to do anything different.
I have a trigger cell which will input the value 1 when I want it to save. The code removes all values except what I want it to keep, then should save down, but since turning on saveasUI, it fails.
Is there a way I can code it to say, turn off saveasUI, run this code, turn on saveasUI?
Many thanks
Kempes
I can't quite find the solution to this issue.
I am using saveasUI to disable the save option, but I do have a scenerio where I would like the user to be able to save.
It is all locked down in the code, so the user basically doesn't have to do anything different.
I have a trigger cell which will input the value 1 when I want it to save. The code removes all values except what I want it to keep, then should save down, but since turning on saveasUI, it fails.
Is there a way I can code it to say, turn off saveasUI, run this code, turn on saveasUI?
Many thanks
Kempes