K
KG
I have a table with three descriptive columns (A, B, C) and three data
columns (D, E, F) showing sales for 2005, 2006 and 2007 Forecast. Columns D-F
are linked to another worksheet in the same workbook from where they draw
their numbers.
I have created 3 macro buttons that sort the data set in descending order
according to 2005, 2006, sales, according to the user's preference. Even
though I have left the entire data set and the source cells unprotected, the
macros stop working and return a "1004 error" when I apply a global
protection macro to the workbook. What could be the problem? Do I need to
write code in the global protection macro that specifically permits data
sorts?
columns (D, E, F) showing sales for 2005, 2006 and 2007 Forecast. Columns D-F
are linked to another worksheet in the same workbook from where they draw
their numbers.
I have created 3 macro buttons that sort the data set in descending order
according to 2005, 2006, sales, according to the user's preference. Even
though I have left the entire data set and the source cells unprotected, the
macros stop working and return a "1004 error" when I apply a global
protection macro to the workbook. What could be the problem? Do I need to
write code in the global protection macro that specifically permits data
sorts?