Desertbird
New Member
- Joined
- Jul 21, 2021
- Messages
- 16
- Office Version
- 2016
- Platform
- Windows
- Mobile
Hello,
I have a document for data entry, with 2 macro buttons, one in A1 (add) and one one B1 (edit). I have the buttons working but want to set the page so that multiple users can add, save and edit entries. However I want them to only do this via the buttons. I still want them to be able to filter the table as well. Is there a way I can set this up? I'm familiar with Sharing the workbook, but not to only allow certain functions.
Thanks for any help!
I have a document for data entry, with 2 macro buttons, one in A1 (add) and one one B1 (edit). I have the buttons working but want to set the page so that multiple users can add, save and edit entries. However I want them to only do this via the buttons. I still want them to be able to filter the table as well. Is there a way I can set this up? I'm familiar with Sharing the workbook, but not to only allow certain functions.
Thanks for any help!