Addin W/ Ribbon: Restict Users from clicking buttons from wrong sheet.

So on top of checking the sheet name, you can also make the code check for the contents in the sheet. Like if you have a certain header / text in that certain cell that none other sheets have, that can be used as a check. Or have a hidden value somewhere in that sheet that can't be noticed easily. Or check for the sheet's code name, like instead of using Sheets("Upload"), maybe use Sheet3 (if it's the third worksheet).

Originally Posted by millz

So on top of checking the sheet name, you can also make the code check for the contents in the sheet. Like if you have a certain header / text in that certain cell that none other sheets have, that can be used as a check. Or have a hidden value somewhere in that sheet that can't be noticed easily. Or check for the sheet's code name, like instead of using Sheets("Upload"), maybe use Sheet3 (if it's the third worksheet).

When the "Download Data" is clicked, I create a sheet and name it "Staffing Plan". The complication I have with checking a header or hidden text is that if a user saves the file after downloading the data, when he reopens the file, he will have access to all the buttons because the header/hidden value still exist in the sheet and he will be able to click "Upload data" with the old Data.

If I create a global variable gsSheetCheckin the addin and load it with a generated number when "Download Data" is clicked, and save the same to sheets("Staffing Plan").Range{"A1"). I can check gsSheetCheck against Range("A1") on any sheet the user clicks the button from. since the global variable will start with a NULL for every new instance of excel, I think this will prevent OLD data to be uploaded. Please advice if this is a good approach.

So is the concern now still "whether is the user on the correct sheet"?

I am not sure of your process. The user must first download data, before upload data can be clicked? If that's the case, can you not make the upload button be disabled by default?

Originally Posted by millz

So is the concern now still "whether is the user on the correct sheet"?

I am not sure of your process. The user must first download data, before upload data can be clicked? If that's the case, can you not make the upload button be disabled by default?

Millz,

This is what I did and works good. This will prevent the user from clicking the button while in the wrong sheet(Even if it has all the same header info). gsSheetVerify is a global variable(String).

Please Login or Register  to view this content.

when the user clicks a button I am checking the following.

Please Login or Register  to view this content.