Hi
i have an excel file in which one staff should edit & review and remaining 4 staffs should only review.
i will keep the excel shortcut on their desktops.
how to share the excel file at a time.
Thanks
Hi
i have an excel file in which one staff should edit & review and remaining 4 staffs should only review.
i will keep the excel shortcut on their desktops.
how to share the excel file at a time.
Thanks
You can do this by create a login form with password and then use protection criteria for 4 staff which you want to review only with code
![]()
Sheet1.Protect Password := "your password"
Kamboj
_________________________________________________________________________________
Mark the thread as SOLVED if my answer satisfy you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks