The proper syntax would be either Activeworkbook.UserStatus or ThisWorkbook.UserStatus.
The (1,1) refers to the name of the user(s). In my case it only returns 1 name as a string so I don't get the meaning of the following lines of the code.
The proper syntax would be either Activeworkbook.UserStatus or ThisWorkbook.UserStatus.
The (1,1) refers to the name of the user(s). In my case it only returns 1 name as a string so I don't get the meaning of the following lines of the code.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks