Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable from deleting rows; folders not to delete; sheets to inser
Dear All
Need guidance for the flg: 1. Sheets to be unprotected but must disable the option to delete any rows and columns or cells. Is it possbile to enter a code in the worksheet?? 2. Any idea to stop deleting the folders in windows bcos in the vb the current workbook will be saved in a folder but some new ppl come and delete the folder in windows and the program gives errors. 3. In the program the current sheet is deleted and inserts new data and renames it to the old sheet name. Due to some wrongful entries the program aborts after deleting the sheet. In that case when the program is run it will error as the sheet is not present and hence want a line of vb to say if the sheet 'report' is missing then Sheets.Add().Name = "report" so that the program can continue. Pls help Brgds/captgnvr |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable from deleting rows; folders not to delete; sheets to inser
Found = False For each Sht in sheets if Sht.Name = "report" then Found = True exit for end if next Sht If found = False then Sheets.Add().Name = "report" end if -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=145627 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
disable from deleting rows; folders not to delete; sheets to i
D/Joel
I was waiting for notification to my email id and never got any. I took the chance to see if any answer then I found your response and hence sorry for the delay in ack. Just saw ur help. will read up the links and revert. Thanks for the tips and will try the code also n wl rvrt. brgds/captgnvr "joel" wrote: Found = False For each Sht in sheets if Sht.Name = "report" then Found = True exit for end if next Sht If found = False then Sheets.Add().Name = "report" end if -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=145627 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable inserting or deleting row in selection of rows | Excel Programming | |||
inserting deleting rows?how do i get the other sheets to do the sa | Excel Discussion (Misc queries) | |||
Block inser or delete rows | Excel Programming | |||
Disable Adding & Deleting Rows/Columns | Excel Discussion (Misc queries) | |||
Disable Adding or Deleting Rows and Columns | Excel Discussion (Misc queries) |