ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to know (https://www.excelbanter.com/excel-programming/353163-how-know.html)

[email protected]

How to know
 
I have a problem at hand.
I have a excel sheet which is circulated among few people.

I want to know when someone has inserted any column in a worksheet. I
dont want to write protect the sheet. But I want to know when someone
inserts a column.

If anyone has done this before. please send me the code


Gary''s Student

How to know
 
Place a non-blank value in cell IU65536 prior to circulation. If anyone
inserts a column, the cell contents will be moved over.
--
Gary''s Student


" wrote:

I have a problem at hand.
I have a excel sheet which is circulated among few people.

I want to know when someone has inserted any column in a worksheet. I
dont want to write protect the sheet. But I want to know when someone
inserts a column.

If anyone has done this before. please send me the code




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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com