Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 14th 09, 05:43 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 74
Default Unable to sort protected table

Hola,

I'm using Excel 2007.
I have an Inserted Table (not a pivot table) on a worksheet and have
autofilter on.
I protected some formulas on the table and then protected the worksheet with
the following command:

ActiveSheet.Protect DrawingObjects:=False, contents:=True, Scenarios:= _
True, AllowFormattingCells:=True, AllowFormattingColumns:=True, _
AllowFormattingRows:=True, AllowSorting:=True, AllowFiltering:=True, _
AllowUsingPivotTables:=True, userInterfaceOnly:=True,
Password:="password1"

The problem is that everytime I need to sort a column I get the following
message:

"The cell or chart you are trying to change is protected and therefore
read-only. Unprotect the worksheet by going to ........"

As you can imaging, this is not acceptable, since the whole purpose is to
protect the formulas being seen/changed by the user.

Any suggestions?

  #2   Report Post  
Old September 18th 09, 09:18 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2007
Posts: 50
Default Unable to sort protected table

Unprotect the sheet, sort, then protect.


--
* Please click Yes if this was helpful *
Andy Smith
Senior Systems Analyst
Standard & Poor''s, NYC



"OMER" wrote:

Hola,

I'm using Excel 2007.
I have an Inserted Table (not a pivot table) on a worksheet and have
autofilter on.
I protected some formulas on the table and then protected the worksheet with
the following command:

ActiveSheet.Protect DrawingObjects:=False, contents:=True, Scenarios:= _
True, AllowFormattingCells:=True, AllowFormattingColumns:=True, _
AllowFormattingRows:=True, AllowSorting:=True, AllowFiltering:=True, _
AllowUsingPivotTables:=True, userInterfaceOnly:=True,
Password:="password1"

The problem is that everytime I need to sort a column I get the following
message:

"The cell or chart you are trying to change is protected and therefore
read-only. Unprotect the worksheet by going to ........"

As you can imaging, this is not acceptable, since the whole purpose is to
protect the formulas being seen/changed by the user.

Any suggestions?

  #3   Report Post  
Old September 18th 09, 09:26 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 74
Default Unable to sort protected table

Hola Andy.
The workbook I'm talking about is being used by many other users.
To maintain integrity, they are not allow to unprotect the worksheet.
Any other suggestions?
Regards,
OMER

"Andy Smith" wrote:

Unprotect the sheet, sort, then protect.


--
* Please click Yes if this was helpful *
Andy Smith
Senior Systems Analyst
Standard & Poor''s, NYC



"OMER" wrote:

Hola,

I'm using Excel 2007.
I have an Inserted Table (not a pivot table) on a worksheet and have
autofilter on.
I protected some formulas on the table and then protected the worksheet with
the following command:

ActiveSheet.Protect DrawingObjects:=False, contents:=True, Scenarios:= _
True, AllowFormattingCells:=True, AllowFormattingColumns:=True, _
AllowFormattingRows:=True, AllowSorting:=True, AllowFiltering:=True, _
AllowUsingPivotTables:=True, userInterfaceOnly:=True,
Password:="password1"

The problem is that everytime I need to sort a column I get the following
message:

"The cell or chart you are trying to change is protected and therefore
read-only. Unprotect the worksheet by going to ........"

As you can imaging, this is not acceptable, since the whole purpose is to
protect the formulas being seen/changed by the user.

Any suggestions?

  #4   Report Post  
Old September 19th 09, 01:49 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Unable to sort protected table

Do it all in the macro which users run from a button or menu.

Sub sortit()
ActiveSheet.Unprotect Password:="justme"

'your sorting code goes here and does the sort

ActiveSheet.Protect Password:="justme"
End Sub

You can hide the code from users by locking the project with a unique
password.


Gord Dibben MS Excel MVP

On Fri, 18 Sep 2009 13:26:02 -0700, OMER
wrote:

Hola Andy.
The workbook I'm talking about is being used by many other users.
To maintain integrity, they are not allow to unprotect the worksheet.
Any other suggestions?
Regards,
OMER

"Andy Smith" wrote:

Unprotect the sheet, sort, then protect.


--
* Please click Yes if this was helpful *
Andy Smith
Senior Systems Analyst
Standard & Poor''s, NYC



"OMER" wrote:

Hola,

I'm using Excel 2007.
I have an Inserted Table (not a pivot table) on a worksheet and have
autofilter on.
I protected some formulas on the table and then protected the worksheet with
the following command:

ActiveSheet.Protect DrawingObjects:=False, contents:=True, Scenarios:= _
True, AllowFormattingCells:=True, AllowFormattingColumns:=True, _
AllowFormattingRows:=True, AllowSorting:=True, AllowFiltering:=True, _
AllowUsingPivotTables:=True, userInterfaceOnly:=True,
Password:="password1"

The problem is that everytime I need to sort a column I get the following
message:

"The cell or chart you are trying to change is protected and therefore
read-only. Unprotect the worksheet by going to ........"

As you can imaging, this is not acceptable, since the whole purpose is to
protect the formulas being seen/changed by the user.

Any suggestions?


  #5   Report Post  
Old September 19th 09, 06:50 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 74
Default Unable to sort protected table

Hola Gord,
This work if you sort within a macro.
The situation is that I've activated the auto-filtering for columns (several
columns) and the user can filter and sort on any of them. Some columns have
formulas, that's why I need to protect the worksheet.
The curious thing is that I can filter even with protection On but when I
try to sort, it wouldn't let me.
If I do this on a named ranged, I can do it. If I do it with a table (Not
pivot table), then it doesn't work.

Any other ideas?
Regards,
OMER

"Gord Dibben" wrote:

Do it all in the macro which users run from a button or menu.

Sub sortit()
ActiveSheet.Unprotect Password:="justme"

'your sorting code goes here and does the sort

ActiveSheet.Protect Password:="justme"
End Sub

You can hide the code from users by locking the project with a unique
password.


Gord Dibben MS Excel MVP

On Fri, 18 Sep 2009 13:26:02 -0700, OMER
wrote:

Hola Andy.
The workbook I'm talking about is being used by many other users.
To maintain integrity, they are not allow to unprotect the worksheet.
Any other suggestions?
Regards,
OMER

"Andy Smith" wrote:

Unprotect the sheet, sort, then protect.


--
* Please click Yes if this was helpful *
Andy Smith
Senior Systems Analyst
Standard & Poor''s, NYC



"OMER" wrote:

Hola,

I'm using Excel 2007.
I have an Inserted Table (not a pivot table) on a worksheet and have
autofilter on.
I protected some formulas on the table and then protected the worksheet with
the following command:

ActiveSheet.Protect DrawingObjects:=False, contents:=True, Scenarios:= _
True, AllowFormattingCells:=True, AllowFormattingColumns:=True, _
AllowFormattingRows:=True, AllowSorting:=True, AllowFiltering:=True, _
AllowUsingPivotTables:=True, userInterfaceOnly:=True,
Password:="password1"

The problem is that everytime I need to sort a column I get the following
message:

"The cell or chart you are trying to change is protected and therefore
read-only. Unprotect the worksheet by going to ........"

As you can imaging, this is not acceptable, since the whole purpose is to
protect the formulas being seen/changed by the user.

Any suggestions?





  #6   Report Post  
Old September 19th 09, 05:36 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Unable to sort protected table

You have created a Table.

You have locked some of the cells within that Table.

You have protected the sheet.

You want to sort or filter on columns within that table.

I don't know how you are going to this without unprotecting the sheet.

You cannot lock part of a Table without sheet protection enabled.


Gord

On Fri, 18 Sep 2009 22:50:01 -0700, OMER
wrote:

Hola Gord,
This work if you sort within a macro.
The situation is that I've activated the auto-filtering for columns (several
columns) and the user can filter and sort on any of them. Some columns have
formulas, that's why I need to protect the worksheet.
The curious thing is that I can filter even with protection On but when I
try to sort, it wouldn't let me.
If I do this on a named ranged, I can do it. If I do it with a table (Not
pivot table), then it doesn't work.

Any other ideas?
Regards,
OMER

"Gord Dibben" wrote:

Do it all in the macro which users run from a button or menu.

Sub sortit()
ActiveSheet.Unprotect Password:="justme"

'your sorting code goes here and does the sort

ActiveSheet.Protect Password:="justme"
End Sub

You can hide the code from users by locking the project with a unique
password.


Gord Dibben MS Excel MVP

On Fri, 18 Sep 2009 13:26:02 -0700, OMER
wrote:

Hola Andy.
The workbook I'm talking about is being used by many other users.
To maintain integrity, they are not allow to unprotect the worksheet.
Any other suggestions?
Regards,
OMER

"Andy Smith" wrote:

Unprotect the sheet, sort, then protect.


--
* Please click Yes if this was helpful *
Andy Smith
Senior Systems Analyst
Standard & Poor''s, NYC



"OMER" wrote:

Hola,

I'm using Excel 2007.
I have an Inserted Table (not a pivot table) on a worksheet and have
autofilter on.
I protected some formulas on the table and then protected the worksheet with
the following command:

ActiveSheet.Protect DrawingObjects:=False, contents:=True, Scenarios:= _
True, AllowFormattingCells:=True, AllowFormattingColumns:=True, _
AllowFormattingRows:=True, AllowSorting:=True, AllowFiltering:=True, _
AllowUsingPivotTables:=True, userInterfaceOnly:=True,
Password:="password1"

The problem is that everytime I need to sort a column I get the following
message:

"The cell or chart you are trying to change is protected and therefore
read-only. Unprotect the worksheet by going to ........"

As you can imaging, this is not acceptable, since the whole purpose is to
protect the formulas being seen/changed by the user.

Any suggestions?




  #7   Report Post  
Old September 19th 09, 07:58 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 74
Default Unable to sort protected table

Hola Gord,
Actually, when you protect the worksheet, you have the option to allow the
user to filter and sort. I have those enabled and, as I say, I can filter
(with the protected worksheet) but cannot sort.
I tried this with simple ranges (that is, not tables) and it does work. But
with tables it doesn't.
I guess that either a bug or an undocumented lack of capability.
REgards,
Oscar

"Gord Dibben" wrote:

You have created a Table.

You have locked some of the cells within that Table.

You have protected the sheet.

You want to sort or filter on columns within that table.

I don't know how you are going to this without unprotecting the sheet.

You cannot lock part of a Table without sheet protection enabled.


Gord

On Fri, 18 Sep 2009 22:50:01 -0700, OMER
wrote:

Hola Gord,
This work if you sort within a macro.
The situation is that I've activated the auto-filtering for columns (several
columns) and the user can filter and sort on any of them. Some columns have
formulas, that's why I need to protect the worksheet.
The curious thing is that I can filter even with protection On but when I
try to sort, it wouldn't let me.
If I do this on a named ranged, I can do it. If I do it with a table (Not
pivot table), then it doesn't work.

Any other ideas?
Regards,
OMER

"Gord Dibben" wrote:

Do it all in the macro which users run from a button or menu.

Sub sortit()
ActiveSheet.Unprotect Password:="justme"

'your sorting code goes here and does the sort

ActiveSheet.Protect Password:="justme"
End Sub

You can hide the code from users by locking the project with a unique
password.


Gord Dibben MS Excel MVP

On Fri, 18 Sep 2009 13:26:02 -0700, OMER
wrote:

Hola Andy.
The workbook I'm talking about is being used by many other users.
To maintain integrity, they are not allow to unprotect the worksheet.
Any other suggestions?
Regards,
OMER

"Andy Smith" wrote:

Unprotect the sheet, sort, then protect.


--
* Please click Yes if this was helpful *
Andy Smith
Senior Systems Analyst
Standard & Poor''s, NYC



"OMER" wrote:

Hola,

I'm using Excel 2007.
I have an Inserted Table (not a pivot table) on a worksheet and have
autofilter on.
I protected some formulas on the table and then protected the worksheet with
the following command:

ActiveSheet.Protect DrawingObjects:=False, contents:=True, Scenarios:= _
True, AllowFormattingCells:=True, AllowFormattingColumns:=True, _
AllowFormattingRows:=True, AllowSorting:=True, AllowFiltering:=True, _
AllowUsingPivotTables:=True, userInterfaceOnly:=True,
Password:="password1"

The problem is that everytime I need to sort a column I get the following
message:

"The cell or chart you are trying to change is protected and therefore
read-only. Unprotect the worksheet by going to ........"

As you can imaging, this is not acceptable, since the whole purpose is to
protect the formulas being seen/changed by the user.

Any suggestions?




  #8   Report Post  
Old September 19th 09, 11:00 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Unable to sort protected table

You can sort on a protected sheet as long as your sort range does not
contain any locked cells.

Example...................A1:G20 cells are all unlocked and sheet protected.

You can sort that range.

If one cell within that range is locked, you cannot sort that range.

I don't think this is documented but stands to reason that if you lock a
cell you should not be able to move it, which sort wants to do.


Gord


On Sat, 19 Sep 2009 11:58:01 -0700, OMER
wrote:

Hola Gord,
Actually, when you protect the worksheet, you have the option to allow the
user to filter and sort. I have those enabled and, as I say, I can filter
(with the protected worksheet) but cannot sort.
I tried this with simple ranges (that is, not tables) and it does work. But
with tables it doesn't.
I guess that either a bug or an undocumented lack of capability.
REgards,
Oscar

"Gord Dibben" wrote:

You have created a Table.

You have locked some of the cells within that Table.

You have protected the sheet.

You want to sort or filter on columns within that table.

I don't know how you are going to this without unprotecting the sheet.

You cannot lock part of a Table without sheet protection enabled.


Gord

On Fri, 18 Sep 2009 22:50:01 -0700, OMER
wrote:

Hola Gord,
This work if you sort within a macro.
The situation is that I've activated the auto-filtering for columns (several
columns) and the user can filter and sort on any of them. Some columns have
formulas, that's why I need to protect the worksheet.
The curious thing is that I can filter even with protection On but when I
try to sort, it wouldn't let me.
If I do this on a named ranged, I can do it. If I do it with a table (Not
pivot table), then it doesn't work.

Any other ideas?
Regards,
OMER

"Gord Dibben" wrote:

Do it all in the macro which users run from a button or menu.

Sub sortit()
ActiveSheet.Unprotect Password:="justme"

'your sorting code goes here and does the sort

ActiveSheet.Protect Password:="justme"
End Sub

You can hide the code from users by locking the project with a unique
password.


Gord Dibben MS Excel MVP

On Fri, 18 Sep 2009 13:26:02 -0700, OMER
wrote:

Hola Andy.
The workbook I'm talking about is being used by many other users.
To maintain integrity, they are not allow to unprotect the worksheet.
Any other suggestions?
Regards,
OMER

"Andy Smith" wrote:

Unprotect the sheet, sort, then protect.


--
* Please click Yes if this was helpful *
Andy Smith
Senior Systems Analyst
Standard & Poor''s, NYC



"OMER" wrote:

Hola,

I'm using Excel 2007.
I have an Inserted Table (not a pivot table) on a worksheet and have
autofilter on.
I protected some formulas on the table and then protected the worksheet with
the following command:

ActiveSheet.Protect DrawingObjects:=False, contents:=True, Scenarios:= _
True, AllowFormattingCells:=True, AllowFormattingColumns:=True, _
AllowFormattingRows:=True, AllowSorting:=True, AllowFiltering:=True, _
AllowUsingPivotTables:=True, userInterfaceOnly:=True,
Password:="password1"

The problem is that everytime I need to sort a column I get the following
message:

"The cell or chart you are trying to change is protected and therefore
read-only. Unprotect the worksheet by going to ........"

As you can imaging, this is not acceptable, since the whole purpose is to
protect the formulas being seen/changed by the user.

Any suggestions?





  #9   Report Post  
Old September 20th 09, 02:33 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 74
Default Unable to sort protected table

I understand that, but again.
This situation applies only to tables. If I have a normal range, and within
that range (A1:G20 in your example) is a normal range, even with the sheet
protected I'm able to sort.

The problem when I define a table (not pivoy table) for that same range.
Then I cannot sort.

Make sense?
Regards,
OMER

"Gord Dibben" wrote:

You can sort on a protected sheet as long as your sort range does not
contain any locked cells.

Example...................A1:G20 cells are all unlocked and sheet protected.

You can sort that range.

If one cell within that range is locked, you cannot sort that range.

I don't think this is documented but stands to reason that if you lock a
cell you should not be able to move it, which sort wants to do.


Gord


On Sat, 19 Sep 2009 11:58:01 -0700, OMER
wrote:

Hola Gord,
Actually, when you protect the worksheet, you have the option to allow the
user to filter and sort. I have those enabled and, as I say, I can filter
(with the protected worksheet) but cannot sort.
I tried this with simple ranges (that is, not tables) and it does work. But
with tables it doesn't.
I guess that either a bug or an undocumented lack of capability.
REgards,
Oscar

"Gord Dibben" wrote:

You have created a Table.

You have locked some of the cells within that Table.

You have protected the sheet.

You want to sort or filter on columns within that table.

I don't know how you are going to this without unprotecting the sheet.

You cannot lock part of a Table without sheet protection enabled.


Gord

On Fri, 18 Sep 2009 22:50:01 -0700, OMER
wrote:

Hola Gord,
This work if you sort within a macro.
The situation is that I've activated the auto-filtering for columns (several
columns) and the user can filter and sort on any of them. Some columns have
formulas, that's why I need to protect the worksheet.
The curious thing is that I can filter even with protection On but when I
try to sort, it wouldn't let me.
If I do this on a named ranged, I can do it. If I do it with a table (Not
pivot table), then it doesn't work.

Any other ideas?
Regards,
OMER

"Gord Dibben" wrote:

Do it all in the macro which users run from a button or menu.

Sub sortit()
ActiveSheet.Unprotect Password:="justme"

'your sorting code goes here and does the sort

ActiveSheet.Protect Password:="justme"
End Sub

You can hide the code from users by locking the project with a unique
password.


Gord Dibben MS Excel MVP

On Fri, 18 Sep 2009 13:26:02 -0700, OMER
wrote:

Hola Andy.
The workbook I'm talking about is being used by many other users.
To maintain integrity, they are not allow to unprotect the worksheet.
Any other suggestions?
Regards,
OMER

"Andy Smith" wrote:

Unprotect the sheet, sort, then protect.


--
* Please click Yes if this was helpful *
Andy Smith
Senior Systems Analyst
Standard & Poor''s, NYC



"OMER" wrote:

Hola,

I'm using Excel 2007.
I have an Inserted Table (not a pivot table) on a worksheet and have
autofilter on.
I protected some formulas on the table and then protected the worksheet with
the following command:

ActiveSheet.Protect DrawingObjects:=False, contents:=True, Scenarios:= _
True, AllowFormattingCells:=True, AllowFormattingColumns:=True, _
AllowFormattingRows:=True, AllowSorting:=True, AllowFiltering:=True, _
AllowUsingPivotTables:=True, userInterfaceOnly:=True,
Password:="password1"

The problem is that everytime I need to sort a column I get the following
message:

"The cell or chart you are trying to change is protected and therefore
read-only. Unprotect the worksheet by going to ........"

As you can imaging, this is not acceptable, since the whole purpose is to
protect the formulas being seen/changed by the user.

Any suggestions?






  #10   Report Post  
Old September 20th 09, 03:22 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,908
Default Unable to sort protected table

Does your Table range contain even one locked cell?

If so, same rules apply.


Gord

On Sat, 19 Sep 2009 18:33:01 -0700, OMER
wrote:

I understand that, but again.
This situation applies only to tables. If I have a normal range, and within
that range (A1:G20 in your example) is a normal range, even with the sheet
protected I'm able to sort.

The problem when I define a table (not pivoy table) for that same range.
Then I cannot sort.

Make sense?
Regards,
OMER

"Gord Dibben" wrote:

You can sort on a protected sheet as long as your sort range does not
contain any locked cells.

Example...................A1:G20 cells are all unlocked and sheet protected.

You can sort that range.

If one cell within that range is locked, you cannot sort that range.

I don't think this is documented but stands to reason that if you lock a
cell you should not be able to move it, which sort wants to do.


Gord


On Sat, 19 Sep 2009 11:58:01 -0700, OMER
wrote:

Hola Gord,
Actually, when you protect the worksheet, you have the option to allow the
user to filter and sort. I have those enabled and, as I say, I can filter
(with the protected worksheet) but cannot sort.
I tried this with simple ranges (that is, not tables) and it does work. But
with tables it doesn't.
I guess that either a bug or an undocumented lack of capability.
REgards,
Oscar

"Gord Dibben" wrote:

You have created a Table.

You have locked some of the cells within that Table.

You have protected the sheet.

You want to sort or filter on columns within that table.

I don't know how you are going to this without unprotecting the sheet.

You cannot lock part of a Table without sheet protection enabled.


Gord

On Fri, 18 Sep 2009 22:50:01 -0700, OMER
wrote:

Hola Gord,
This work if you sort within a macro.
The situation is that I've activated the auto-filtering for columns (several
columns) and the user can filter and sort on any of them. Some columns have
formulas, that's why I need to protect the worksheet.
The curious thing is that I can filter even with protection On but when I
try to sort, it wouldn't let me.
If I do this on a named ranged, I can do it. If I do it with a table (Not
pivot table), then it doesn't work.

Any other ideas?
Regards,
OMER

"Gord Dibben" wrote:

Do it all in the macro which users run from a button or menu.

Sub sortit()
ActiveSheet.Unprotect Password:="justme"

'your sorting code goes here and does the sort

ActiveSheet.Protect Password:="justme"
End Sub

You can hide the code from users by locking the project with a unique
password.


Gord Dibben MS Excel MVP

On Fri, 18 Sep 2009 13:26:02 -0700, OMER
wrote:

Hola Andy.
The workbook I'm talking about is being used by many other users.
To maintain integrity, they are not allow to unprotect the worksheet.
Any other suggestions?
Regards,
OMER

"Andy Smith" wrote:

Unprotect the sheet, sort, then protect.


--
* Please click Yes if this was helpful *
Andy Smith
Senior Systems Analyst
Standard & Poor''s, NYC



"OMER" wrote:

Hola,

I'm using Excel 2007.
I have an Inserted Table (not a pivot table) on a worksheet and have
autofilter on.
I protected some formulas on the table and then protected the worksheet with
the following command:

ActiveSheet.Protect DrawingObjects:=False, contents:=True, Scenarios:= _
True, AllowFormattingCells:=True, AllowFormattingColumns:=True, _
AllowFormattingRows:=True, AllowSorting:=True, AllowFiltering:=True, _
AllowUsingPivotTables:=True, userInterfaceOnly:=True,
Password:="password1"

The problem is that everytime I need to sort a column I get the following
message:

"The cell or chart you are trying to change is protected and therefore
read-only. Unprotect the worksheet by going to ........"

As you can imaging, this is not acceptable, since the whole purpose is to
protect the formulas being seen/changed by the user.

Any suggestions?









Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I allow users to sort a protected table using dropdowns? Stuart Hodge Excel Worksheet Functions 1 April 6th 10 02:10 PM
Allowing users to use filters and sort on protected pivot table Michael Excel Discussion (Misc queries) 0 October 15th 09 05:29 PM
Allowing users to use filters and sort on protected pivot table Michael Excel Discussion (Misc queries) 0 October 15th 09 05:18 PM
Can I sort a table using a macro in a protected worksheet? Edgar[_2_] Excel Programming 1 June 8th 05 07:33 PM
Unable to use controls when sheet is protected Tom Ogilvy Excel Programming 1 August 10th 04 04:08 PM


All times are GMT +1. The time now is 06:06 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017