Results 1 to 4 of 4

Add/Delete rows between intervals in single/multiple worksheets with password

Threaded View

jokris Add/Delete rows between... 03-19-2016, 01:25 AM
FDibbins Re: Add/Delete rows between... 03-19-2016, 01:39 AM
jokris Re: Add/Delete rows between... 03-19-2016, 01:44 AM
dominicb Re: Add/Delete rows between... 03-20-2016, 04:09 AM
  1. #1
    Forum Contributor
    Join Date
    11-23-2015
    Location
    Yada, Wales
    MS-Off Ver
    Office 2013
    Posts
    176

    Add/Delete rows between intervals in single/multiple worksheets with password

    Having trouble with adding or deleting rows manually, would be great to do this by vba (which I have no experience of)
    I feel that I have to try to specify as good as I can what I would like the codes to do (four different types of codes):

    ADDING

    Adding copies of row 1 on active sheet:
    1) Dialog box asks how many new copies of row 1 on active sheet that I want
    2) New dialog box asks to select a row with mouse where the copies shall be inserted.
    3) If step 1 or 2 is cancelled, do not insert rows or display any error message
    4) If selected row is less than row number 6 (that is row number 1-5), a dialog box tells it is not possible to add copies here. Code ends.
    5) If selected row is more than the row number that contains the word "maximum", a dialog box tells it is not possible to add copies here. Code ends.
    6) Otherwise, password is unprotected, code executed and password protected again.
    7) Return to page where code was executed


    Adding copies of row 1 on similar multiple sheets:
    1) Dialog box asks how many new copies of row 1 on each of three sheets A, B and C that I want
    2) New dialog box asks to select a row with mouse where the copies shall be inserted.
    3) If step 1 or 2 is cancelled, do not insert rows or display any error message
    4) If selected row is less than row number 6 (that is row number 1-5), a dialog box tells it is not possible to add copies here. Code ends.
    5) If selected row is more than the row number that contains the word "maximum", a dialog box tells it is not possible to add copies here. Code ends.
    6) Otherwise, password (same on all sheets) are unprotected, code executed (copies of row 1 inserted on same row of each sheet) and password protected again.
    7) Return to page where code was executed


    DELETING

    Deleting rows on active sheet:
    1) Dialog box asks me to select with mouse what rows I want to be deleted
    2) If cancelled, do not delete rows or display any error message.
    3) If selected row is less than row number 6 (that is row number 1-5), a dialog box tells it is not possible to delete rows here. Code ends.
    4) If selected row is more than the row number that contains the word "maximum", a dialog box tells it is not possible to delete these rows. Code ends.
    5) Otherwise, password is unprotected, code executed and password protected again.
    6) Return to page where code was executed


    Deleting rows on multiple sheets:
    1) Dialog box asks me to select with mouse what rows I want to be deleted
    2) If cancelled, do not delete rows or display any error message.
    3) If selected row is less than row number 6 (that is row number 1-5), a dialog box tells it is not possible to delete rows here. Code ends.
    4) If selected row is more than the row number that contains the word "maximum", a dialog box tells it is not possible to delete these rows. Code ends.
    5) Otherwise, passwords are unprotected (same on all sheets), code executed (same row numbers deleted on all sheets) and password protected again.
    6) Return to page where code was executed
    Last edited by jokris; 03-19-2016 at 02:06 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Delete Rows except rows with specific values across multiple uniquely named Worksheets
    By moosetales in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-23-2016, 03:04 PM
  2. Copying multiple rows from multiple worksheets to a single worksheet
    By Malkave in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-09-2012, 06:35 AM
  3. Delete multiple rows of data based on criteria in a single cell
    By slaga9 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2011, 03:41 AM
  4. [SOLVED] adding rows across multiple worksheets within a single workbook
    By frank.freeman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2005, 06:05 PM
  5. [SOLVED] delete rows from multiple worksheets
    By dckrause in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2005, 02:05 AM
  6. delete rows from multiple worksheets
    By dckrause in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-05-2005, 11:05 PM
  7. delete rows from multiple worksheets
    By dckrause in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-31-2005, 11:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1