K. Georgiadis
03-12-2009, 11:45 AM
Hi folks,
The workbook in question is protected globally with a ProtectAll() macro and the user is not savvy enough to mess with VBA.
In one of the worksheets there is a profitability ranking of products, from the most profitable to the least profitable. As the user makes entries in different sections of the workbook, these rankings will change and the ranking table will need re-sorting. I am planning to add a macro button next to the table that will re-sort the table as needed without the user having to get involved in unprotecting/re-protecting the workbook.
My question is this: am I limited to (1) having to program the macro button so that it temporarily unprotects the worksheet and re-protects it after the re-sort or (2) is there an exception that I can add to the ProtectAll routine in the module which will allow the re-sort macro to run without having to run a temporary unprotect?
Many thanks!
The workbook in question is protected globally with a ProtectAll() macro and the user is not savvy enough to mess with VBA.
In one of the worksheets there is a profitability ranking of products, from the most profitable to the least profitable. As the user makes entries in different sections of the workbook, these rankings will change and the ranking table will need re-sorting. I am planning to add a macro button next to the table that will re-sort the table as needed without the user having to get involved in unprotecting/re-protecting the workbook.
My question is this: am I limited to (1) having to program the macro button so that it temporarily unprotects the worksheet and re-protects it after the re-sort or (2) is there an exception that I can add to the ProtectAll routine in the module which will allow the re-sort macro to run without having to run a temporary unprotect?
Many thanks!