Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: VBA code for Submit/Clear Button?

  1. #11
    New Member
    Join Date
    May 2018
    Posts
    30
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA code for Submit/Clear Button?

    By the way Sir, Is there a way to run this macro in a protected workbook?
    I tried this code and it's work, however, the column that contains index match functions doesn't work:
    Code:
    Public Sub AllowMacros()
                  Me.ProtectUserInterfaceOnly:True
               End Sub

  2. #12
    Board Regular Akuini's Avatar
    Join Date
    Feb 2016
    Location
    Indonesia
    Posts
    2,058
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    4 Thread(s)

    Default Re: VBA code for Submit/Clear Button?

    Quote Originally Posted by cyrous0425 View Post
    By the way Sir, Is there a way to run this macro in a protected workbook?
    I tried this code and it's work, however, the column that contains index match functions doesn't work:
    Code:
    Public Sub AllowMacros()
                  Me.ProtectUserInterfaceOnly:True
               End Sub
    Sorry, I don't know the answer. But since it's a different problem you might want to start a new thread.

  3. #13
    New Member
    Join Date
    May 2018
    Posts
    30
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA code for Submit/Clear Button?

    Ok I will. By the way, every time I add new data my formula in column L become inaccurate. Is there a way to solved it?

  4. #14
    Board Regular Akuini's Avatar
    Join Date
    Feb 2016
    Location
    Indonesia
    Posts
    2,058
    Post Thanks / Like
    Mentioned
    36 Post(s)
    Tagged
    4 Thread(s)

    Default Re: VBA code for Submit/Clear Button?

    Hm, my knowledge of excel formula is very basic, so I can't help you with that.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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