Why don't you provide the administative staff with only a copy of the professional staff's workbook ?
You can easily do that using
[VBA]
Workbooks.add "G:\professional.xlsx"
[/VBA]
Or you could make an administrative workbook template, containing a databasequery to the professional staff's workbook.




					
					
					
						
  Reply With Quote