Pass Sheet name as argument to function

Hello Genius,
I am working on user rights in excel sheet. It have around 78 sheets with 3 categories i.e. High Security, Moderate Security and Low security.
I am using macros to switch between sheets. Each sheet can only be accessed by that macro assigned to a button.
Now I am writing a function namely checkAccess(Worksheet name). It have a lot of if's and cases to grant access depending on the current user logged in. The function should take sheet name as input and check access on it. But I am unable to pass sheet name in function.
By using this function I want to call this function in every switching macro and it will do everything else by itself.

Please Login or Register  to view this content.

Originally Posted by TMS

Sounds as though you need

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Regards, TMS

I will check it as soon as I reach home... Where should I put it? in macro like ?

Please Login or Register  to view this content.

Is it ok? I cant test right now.

Originally Posted by Naveed Raza

Assalamualaikum

could you please provide sample workbook with desire output , how extactly your checking for access

Walaekum Assalam.
Sure Naveed. I will provide my sample workbook. But Access program is not yet written . I will provide my algorithm for that. And will post my code as soon as it completes.

its nothing It is good if I keep switching b/w sheets. But that I think is not required now..

Originally Posted by Norie

Umair

There is no way we can tell you how to pass the sheet name to the function without seeing the function you want to pass the sheet name to.

sample security.xlsx
Attached my file.
My code for function is:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

There may b a few syntax mistake in my code. Its not written in excel. Its written in text editor.

Resolved.

Please Login or Register  to view this content.

Originally Posted by TMS

Note that the brackets around the parameter(s) are not necessary.

Thanks for the TIP TMS Please Add my reputation

Originally Posted by TMS

I'm sorry; I don't understand. You add reputation by clicking on the little star at the bottom left of the post.

Or are you expecting me to +rep you?

Hehehehe If you want you can Just kidding

Originally Posted by Norie

Are you sure this is resolved?

The function you posted in post #10 requires a worksheet object passed to it, not a worksheet name.

Yes Norie. I solved the problem myself. POst11 is what i wanted to do. just changed argument to string.