This content has been marked as final. Show 5 replies
Yes, You can. For that user need to write VB script code in excel sheet, in the activate sheet function to check which user will see the uploadable report button and which user not.
I didn't know that you could get at user info inside of vb. Seems scary. Even if that's doable, I'd make two different reports -- one that's updateable and the other not -- and assign them to the appropriate users. Otherwise you'll end up having to maintain security info in multiple places.
InterlaceSession object gives user information like
Can you shed some more light on this ?
You can get logged in user name using the code below in your report
ThisWorkbook.InterlaceSession.Username ---> This will return who is logged in.
Similarly you also have other properties like
Based on these you should be able hide update changes button with simple VB code.