Consulting

Results 1 to 2 of 2

Thread: VB disable conditional formatting code

  1. #1
    VBAX Newbie
    Joined
    Oct 2012
    Posts
    1
    Location

    VB disable conditional formatting code

    Was there a way through VB to disable or not allow any changes to the conditional formatting.

    I am using the disable cut copy paste
    and was looking for something similar but for conditional formatting.

  2. #2
    VBAX Mentor Teeroy's Avatar
    Joined
    Apr 2012
    Location
    Sydney, Australia
    Posts
    414
    Location
    How about formatting the cells that need to be edited as not "Locked" for protection then protecting the sheet disallowing format changes?
    _________________________________________________________________________
    "In theory there is no difference between theory and practice. In practice there is." - Chuck Reid

    Any day you learn something new is a day not wasted.

Posting Permissions

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