HI,
I am wanting a Macro button setup so that when a value is entered into cell E1 and then the button is clicked, a pdf opens up from a folder on X drive.
Refer below snip. (Ignore the Display and Reset buttons, I am just after the Layout button)
Can anyone help me with this please ?
Basically, after something like,
IF Room No. = 224, 324, 424, then OPEN xyz.pdf
IF Room No. = 225, 325, 425, then OPEN abc.pdf and so on and forth
I am wanting a Macro button setup so that when a value is entered into cell E1 and then the button is clicked, a pdf opens up from a folder on X drive.
Refer below snip. (Ignore the Display and Reset buttons, I am just after the Layout button)
Can anyone help me with this please ?
Basically, after something like,
IF Room No. = 224, 324, 424, then OPEN xyz.pdf
IF Room No. = 225, 325, 425, then OPEN abc.pdf and so on and forth
