EBDN - Community - Question & Answers

  Thursday, 02 March 2023
  1 Replies
  728 Visits
0
Votes
Undo
Hello,
i´m creating an assistant, who chreates some objects in less than 2 seconds. This assistant is used several times in a row. This assistant uses a worksheet. I would like to open the worksheet only once, if the worksheet isn't already opened.

How can i see, which (types of) worksheets are already opened?
How can i assign a already opened worksheet to a variable in the VBA script?
How can i read the actual Filter and attributes of this worksheet?