Ask Your Question

Activation sheet and cell by macros [closed]

asked 2020-02-13 04:52:56 +0200

shma_lo gravatar image

How to activate (or go to) special sheet and cell by macros? For example, the active cell is in the sheet "Sheet1", and I want to puch some button to activate cell $B$23 in the sheet "Salary". Windows10, LO

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by shma_lo
close date 2020-02-16 05:17:58.363183

1 Answer

Sort by » oldest newest most voted

answered 2020-02-14 13:13:19 +0200

JohnSUN gravatar image

Try to do this without macro. Just use Hyperlink (Ctrl+K)

image description

If you want to use a macro, then use the .Select() method of the CurrentController of document (see chapter Listing 6.14: Select a single cell so it has an outline. in Andrew Macro Book)

edit flag offensive delete link more


Thanks to JohnSUN

shma_lo gravatar imageshma_lo ( 2020-02-15 23:45:55 +0200 )edit

Question Tools

1 follower


Asked: 2020-02-13 04:52:56 +0200

Seen: 24 times

Last updated: Feb 14