Right now I am using this to protect a sheet in my VBA code:
ActiveSheet.Protect Password:="hello"
But it removes all access to the Home tab in the ribbon. I would like the user to still be able to use the font color and size controls. Along with inserting/deleting rows. Does anyone know how to do this?
Thanks.
ActiveSheet.Protect Password:="hello"
But it removes all access to the Home tab in the ribbon. I would like the user to still be able to use the font color and size controls. Along with inserting/deleting rows. Does anyone know how to do this?
Thanks.