Dear all , i have three worksheets “input”,”output”, and “temp”. here sheet “temp” is not visible . it is being created for processing some activity and after that it deleted during run macro. I want to implement below macro code sothat no one add new sheet except “temp “sheet. below code is working fine if “temp” sheet is not created by macro . how to implement some logic sothat it can ignore the “temp” sheet .
Please Login or Register to view this content.
Last edited by nur2544; 01-29-2015 at 10:03 AM.
Hi,
Could you disable events in your code and then re-enable them when complete?
Please Login or Register to view this content.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Hi Nur,
your problem is ActiveSheet.Delete should be sh.Delete
In workbook change event sh as object is refer to Activesheet
the same thing goes to ActiveCell.Row is refer to Target.Row. Just FYI.
you may try this,
Please Login or Register to view this content.
Last edited by Faridwahidi; 01-29-2015 at 10:58 AM.
Hi sweep , it works perfectly , thanks you very much..
Hi Faridwahidi , it doesn't work for my case. it doesn't allow creating "temp" sheet which is required . earlier i told that no new sheet allowed except “input”,”output”, and “temp”. where temp sheet creating & deleting inside the module itself . but i am telling about no manual intervention to create new sheet . hope got it .
Perhaps this link could be of interest as well?
http://blogmines.com/blog/how-to-pre...in-excel-2010/
Alf
wrong post I apologise.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks