Live-Forum - Die aktuellen Beiträge
Datum
Titel
20.05.2024 07:58:34
Wie Formelberechnung trotz Blattschutz
19.05.2024 19:56:55
Mit Schaltfläche (VBAMacro) zur aktuellen Woche springen
19.05.2024 19:42:43
zeilen löschen wenn
19.05.2024 17:55:54
Problem mit Formel countif
Du findest keine passende Antwort auf Deine Frage?
Stelle Deine Frage in unserem Live-Forum
Anzeige
Archiv - Navigation
1968to1972
Aktuelles Verzeichnis
Verzeichnis Index
Übersicht Verzeichnisse
Vorheriger Thread
Rückwärts Blättern
Nächster Thread
Vorwärts blättern
Anzeige
HERBERS
Excel-Forum (Archiv)
20+ Jahre Excel-Kompetenz: Von Anwendern, für Anwender
Vorheriger Thread
Vorheriger Thread
Rückwärts Blättern
1968to1972
1968to1972
Aktuelles Verzeichnis
Verzeichnis Index
Verzeichnis Index
Übersicht Verzeichnisse
Nächster Thread
Nächster Thread
Vorwärts blättern
Inhaltsverzeichnis

Spalte direkt an Fensterfixierung bringen.

Spalte direkt an Fensterfixierung bringen.
15.03.2024 09:32:58
BlackForestPhoto
Hallo Forum,

ich habe in einem Tabellenblatt eine Fensterfixierung(Spalte C),
und suche nun eine Möglichkeit die Spalte NM z.B.durch klick auf einen Button
direkt an die Fixierung zu bringen. Ich habe es schon mit dem Makroreckorder
versuch aber nicht das gewünschte Ergebnis erziehlt.

Besten Dank im Voraus
Helmut

6
Beiträge zum Forumthread
Beiträge zu diesem Forumthread

Betreff
Datum
Anwender
Anzeige
AW: Spalte direkt an Fensterfixierung bringen.
15.03.2024 09:39:34
BlackForestPhoto
Ich habe es jetzt doch mit dem Makrorecorder erstellen können,
aber läst sich der Code nicht etwas optimieren?
Gruß
Helmut 

Sub Urlaub()

'

' Urlaub Makro

'

' Tastenkombination: Strg+u

'

    ActiveWindow.ScrollColumn = 5

    ActiveWindow.ScrollColumn = 6

    ActiveWindow.ScrollColumn = 7

    ActiveWindow.ScrollColumn = 9

    ActiveWindow.ScrollColumn = 12

    ActiveWindow.ScrollColumn = 15

    ActiveWindow.ScrollColumn = 18

    ActiveWindow.ScrollColumn = 19

    ActiveWindow.ScrollColumn = 20

    ActiveWindow.ScrollColumn = 22

    ActiveWindow.ScrollColumn = 24

    ActiveWindow.ScrollColumn = 25

    ActiveWindow.ScrollColumn = 26

    ActiveWindow.ScrollColumn = 27

    ActiveWindow.ScrollColumn = 28

    ActiveWindow.ScrollColumn = 29

    ActiveWindow.ScrollColumn = 30

    ActiveWindow.ScrollColumn = 32

    ActiveWindow.ScrollColumn = 33

    ActiveWindow.ScrollColumn = 34

    ActiveWindow.ScrollColumn = 35

    ActiveWindow.ScrollColumn = 36

    ActiveWindow.ScrollColumn = 37

    ActiveWindow.ScrollColumn = 38

    ActiveWindow.ScrollColumn = 39

    ActiveWindow.ScrollColumn = 40

    ActiveWindow.ScrollColumn = 42

    ActiveWindow.ScrollColumn = 43

    ActiveWindow.ScrollColumn = 44

    ActiveWindow.ScrollColumn = 46

    ActiveWindow.ScrollColumn = 47

    ActiveWindow.ScrollColumn = 48

    ActiveWindow.ScrollColumn = 49

    ActiveWindow.ScrollColumn = 50

    ActiveWindow.ScrollColumn = 54

    ActiveWindow.ScrollColumn = 55

    ActiveWindow.ScrollColumn = 56

    ActiveWindow.ScrollColumn = 57

    ActiveWindow.ScrollColumn = 58

    ActiveWindow.ScrollColumn = 59

    ActiveWindow.ScrollColumn = 60

    ActiveWindow.ScrollColumn = 61

    ActiveWindow.ScrollColumn = 62

    ActiveWindow.ScrollColumn = 63

    ActiveWindow.ScrollColumn = 64

    ActiveWindow.ScrollColumn = 65

    ActiveWindow.ScrollColumn = 66

    ActiveWindow.ScrollColumn = 67

    ActiveWindow.ScrollColumn = 68

    ActiveWindow.ScrollColumn = 69

    ActiveWindow.ScrollColumn = 70

    ActiveWindow.ScrollColumn = 71

    ActiveWindow.ScrollColumn = 72

    ActiveWindow.ScrollColumn = 73

    ActiveWindow.ScrollColumn = 74

    ActiveWindow.ScrollColumn = 75

    ActiveWindow.ScrollColumn = 77

    ActiveWindow.ScrollColumn = 78

    ActiveWindow.ScrollColumn = 79

    ActiveWindow.ScrollColumn = 80

    ActiveWindow.ScrollColumn = 81

    ActiveWindow.ScrollColumn = 82

    ActiveWindow.ScrollColumn = 83

    ActiveWindow.ScrollColumn = 84

    ActiveWindow.ScrollColumn = 85

    ActiveWindow.ScrollColumn = 86

    ActiveWindow.ScrollColumn = 87

    ActiveWindow.ScrollColumn = 88

    ActiveWindow.ScrollColumn = 89

    ActiveWindow.ScrollColumn = 90

    ActiveWindow.ScrollColumn = 91

    ActiveWindow.ScrollColumn = 92

    ActiveWindow.ScrollColumn = 93

    ActiveWindow.ScrollColumn = 94

    ActiveWindow.ScrollColumn = 95

    ActiveWindow.ScrollColumn = 96

    ActiveWindow.ScrollColumn = 97

    ActiveWindow.ScrollColumn = 98

    ActiveWindow.ScrollColumn = 99

    ActiveWindow.ScrollColumn = 100

    ActiveWindow.ScrollColumn = 101

    ActiveWindow.ScrollColumn = 102

    ActiveWindow.ScrollColumn = 103

    ActiveWindow.ScrollColumn = 104

    ActiveWindow.ScrollColumn = 105

    ActiveWindow.ScrollColumn = 106

    ActiveWindow.ScrollColumn = 107

    ActiveWindow.ScrollColumn = 108

    ActiveWindow.ScrollColumn = 110

    ActiveWindow.ScrollColumn = 111

    ActiveWindow.ScrollColumn = 112

    ActiveWindow.ScrollColumn = 113

    ActiveWindow.ScrollColumn = 114

    ActiveWindow.ScrollColumn = 115

    ActiveWindow.ScrollColumn = 116

    ActiveWindow.ScrollColumn = 117

    ActiveWindow.ScrollColumn = 118

    ActiveWindow.ScrollColumn = 119

    ActiveWindow.ScrollColumn = 120

    ActiveWindow.ScrollColumn = 121

    ActiveWindow.ScrollColumn = 122

    ActiveWindow.ScrollColumn = 123

    ActiveWindow.ScrollColumn = 124

    ActiveWindow.ScrollColumn = 125

    ActiveWindow.ScrollColumn = 126

    ActiveWindow.ScrollColumn = 127

    ActiveWindow.ScrollColumn = 128

    ActiveWindow.ScrollColumn = 129

    ActiveWindow.ScrollColumn = 130

    ActiveWindow.ScrollColumn = 131

    ActiveWindow.ScrollColumn = 132

    ActiveWindow.ScrollColumn = 133

    ActiveWindow.ScrollColumn = 134

    ActiveWindow.ScrollColumn = 135

    ActiveWindow.ScrollColumn = 136

    ActiveWindow.ScrollColumn = 137

    ActiveWindow.ScrollColumn = 138

    ActiveWindow.ScrollColumn = 139

    ActiveWindow.ScrollColumn = 140

    ActiveWindow.ScrollColumn = 141

    ActiveWindow.ScrollColumn = 142

    ActiveWindow.ScrollColumn = 143

    ActiveWindow.ScrollColumn = 144

    ActiveWindow.ScrollColumn = 145

    ActiveWindow.ScrollColumn = 146

    ActiveWindow.ScrollColumn = 147

    ActiveWindow.ScrollColumn = 148

    ActiveWindow.ScrollColumn = 149

    ActiveWindow.ScrollColumn = 150

    ActiveWindow.ScrollColumn = 151

    ActiveWindow.ScrollColumn = 152

    ActiveWindow.ScrollColumn = 153

    ActiveWindow.ScrollColumn = 154

    ActiveWindow.ScrollColumn = 155

    ActiveWindow.ScrollColumn = 156

    ActiveWindow.ScrollColumn = 157

    ActiveWindow.ScrollColumn = 158

    ActiveWindow.ScrollColumn = 159

    ActiveWindow.ScrollColumn = 160

    ActiveWindow.ScrollColumn = 161

    ActiveWindow.ScrollColumn = 162

    ActiveWindow.ScrollColumn = 163

    ActiveWindow.ScrollColumn = 164

    ActiveWindow.ScrollColumn = 165

    ActiveWindow.ScrollColumn = 166

    ActiveWindow.ScrollColumn = 167

    ActiveWindow.ScrollColumn = 168

    ActiveWindow.ScrollColumn = 169

    ActiveWindow.ScrollColumn = 170

    ActiveWindow.ScrollColumn = 171

    ActiveWindow.ScrollColumn = 172

    ActiveWindow.ScrollColumn = 173

    ActiveWindow.ScrollColumn = 174

    ActiveWindow.ScrollColumn = 175

    ActiveWindow.ScrollColumn = 176

    ActiveWindow.ScrollColumn = 177

    ActiveWindow.ScrollColumn = 178

    ActiveWindow.ScrollColumn = 179

    ActiveWindow.ScrollColumn = 180

    ActiveWindow.ScrollColumn = 181

    ActiveWindow.ScrollColumn = 182

    ActiveWindow.ScrollColumn = 183

    ActiveWindow.ScrollColumn = 184

    ActiveWindow.ScrollColumn = 185

    ActiveWindow.ScrollColumn = 186

    ActiveWindow.ScrollColumn = 187

    ActiveWindow.ScrollColumn = 188

    ActiveWindow.ScrollColumn = 189

    ActiveWindow.ScrollColumn = 190

    ActiveWindow.ScrollColumn = 191

    ActiveWindow.ScrollColumn = 192

    ActiveWindow.ScrollColumn = 193

    ActiveWindow.ScrollColumn = 194

    ActiveWindow.ScrollColumn = 195

    ActiveWindow.ScrollColumn = 196

    ActiveWindow.ScrollColumn = 197

    ActiveWindow.ScrollColumn = 198

    ActiveWindow.ScrollColumn = 199

    ActiveWindow.ScrollColumn = 200

    ActiveWindow.ScrollColumn = 201

    ActiveWindow.ScrollColumn = 202

    ActiveWindow.ScrollColumn = 203

    ActiveWindow.ScrollColumn = 204

    ActiveWindow.ScrollColumn = 205

    ActiveWindow.ScrollColumn = 206

    ActiveWindow.ScrollColumn = 207

    ActiveWindow.ScrollColumn = 208

    ActiveWindow.ScrollColumn = 209

    ActiveWindow.ScrollColumn = 210

    ActiveWindow.ScrollColumn = 211

    ActiveWindow.ScrollColumn = 212

    ActiveWindow.ScrollColumn = 213

    ActiveWindow.ScrollColumn = 214

    ActiveWindow.ScrollColumn = 215

    ActiveWindow.ScrollColumn = 216

    ActiveWindow.ScrollColumn = 217

    ActiveWindow.ScrollColumn = 218

    ActiveWindow.ScrollColumn = 219

    ActiveWindow.ScrollColumn = 220

    ActiveWindow.ScrollColumn = 221

    ActiveWindow.ScrollColumn = 222

    ActiveWindow.ScrollColumn = 223

    ActiveWindow.ScrollColumn = 224

    ActiveWindow.ScrollColumn = 225

    ActiveWindow.ScrollColumn = 226

    ActiveWindow.ScrollColumn = 227

    ActiveWindow.ScrollColumn = 228

    ActiveWindow.ScrollColumn = 229

    ActiveWindow.ScrollColumn = 230

    ActiveWindow.ScrollColumn = 231

    ActiveWindow.ScrollColumn = 232

    ActiveWindow.ScrollColumn = 233

    ActiveWindow.ScrollColumn = 234

    ActiveWindow.ScrollColumn = 235

    ActiveWindow.ScrollColumn = 236

    ActiveWindow.ScrollColumn = 237

    ActiveWindow.ScrollColumn = 238

    ActiveWindow.ScrollColumn = 239

    ActiveWindow.ScrollColumn = 240

    ActiveWindow.ScrollColumn = 241

    ActiveWindow.ScrollColumn = 242

    ActiveWindow.ScrollColumn = 243

    ActiveWindow.ScrollColumn = 244

    ActiveWindow.ScrollColumn = 245

    ActiveWindow.ScrollColumn = 246

    ActiveWindow.ScrollColumn = 247

    ActiveWindow.ScrollColumn = 248

    ActiveWindow.ScrollColumn = 249

    ActiveWindow.ScrollColumn = 250

    ActiveWindow.ScrollColumn = 251

    ActiveWindow.ScrollColumn = 252

    ActiveWindow.ScrollColumn = 253

    ActiveWindow.ScrollColumn = 254

    ActiveWindow.ScrollColumn = 255

    ActiveWindow.ScrollColumn = 256

    ActiveWindow.ScrollColumn = 257

    ActiveWindow.ScrollColumn = 258

    ActiveWindow.ScrollColumn = 259

    ActiveWindow.ScrollColumn = 260

    ActiveWindow.ScrollColumn = 261

    ActiveWindow.ScrollColumn = 262

    ActiveWindow.ScrollColumn = 263

    ActiveWindow.ScrollColumn = 264

    ActiveWindow.ScrollColumn = 265

    ActiveWindow.ScrollColumn = 266

    ActiveWindow.ScrollColumn = 267

    ActiveWindow.ScrollColumn = 268

    ActiveWindow.ScrollColumn = 269

    ActiveWindow.ScrollColumn = 270

    ActiveWindow.ScrollColumn = 271

    ActiveWindow.ScrollColumn = 272

    ActiveWindow.ScrollColumn = 274

    ActiveWindow.ScrollColumn = 275

    ActiveWindow.ScrollColumn = 276

    ActiveWindow.ScrollColumn = 277

    ActiveWindow.ScrollColumn = 278

    ActiveWindow.ScrollColumn = 279

    ActiveWindow.ScrollColumn = 280

    ActiveWindow.ScrollColumn = 281

    ActiveWindow.ScrollColumn = 283

    ActiveWindow.ScrollColumn = 284

    ActiveWindow.ScrollColumn = 285

    ActiveWindow.ScrollColumn = 287

    ActiveWindow.ScrollColumn = 288

    ActiveWindow.ScrollColumn = 289

    ActiveWindow.ScrollColumn = 290

    ActiveWindow.ScrollColumn = 291

    ActiveWindow.ScrollColumn = 292

    ActiveWindow.ScrollColumn = 293

    ActiveWindow.ScrollColumn = 294

    ActiveWindow.ScrollColumn = 295

    ActiveWindow.ScrollColumn = 296

    ActiveWindow.ScrollColumn = 297

    ActiveWindow.ScrollColumn = 298

    ActiveWindow.ScrollColumn = 299

    ActiveWindow.ScrollColumn = 300

    ActiveWindow.ScrollColumn = 301

    ActiveWindow.ScrollColumn = 302

    ActiveWindow.ScrollColumn = 303

    ActiveWindow.ScrollColumn = 305

    ActiveWindow.ScrollColumn = 306

    ActiveWindow.ScrollColumn = 307

    ActiveWindow.ScrollColumn = 308

    ActiveWindow.ScrollColumn = 309

    ActiveWindow.ScrollColumn = 310

    ActiveWindow.ScrollColumn = 311

    ActiveWindow.ScrollColumn = 313

    ActiveWindow.ScrollColumn = 314

    ActiveWindow.ScrollColumn = 316

    ActiveWindow.ScrollColumn = 317

    ActiveWindow.ScrollColumn = 318

    ActiveWindow.ScrollColumn = 319

    ActiveWindow.ScrollColumn = 320

    ActiveWindow.ScrollColumn = 321

    ActiveWindow.ScrollColumn = 322

    ActiveWindow.ScrollColumn = 323

    ActiveWindow.ScrollColumn = 324

    ActiveWindow.ScrollColumn = 325

    ActiveWindow.ScrollColumn = 326

    ActiveWindow.ScrollColumn = 328

    ActiveWindow.ScrollColumn = 329

    ActiveWindow.ScrollColumn = 330

    ActiveWindow.ScrollColumn = 331

    ActiveWindow.ScrollColumn = 332

    ActiveWindow.ScrollColumn = 333

    ActiveWindow.ScrollColumn = 334

    ActiveWindow.SmallScroll ToRight:=43

    Range("NM1").Select

End Sub
Anzeige
AW: Spalte direkt an Fensterfixierung bringen.
15.03.2024 10:15:17
daniel
Hi

activewindow.ScrollColumn = columns("NM").column

Gruß Daniel
AW: Spalte direkt an Fensterfixierung bringen.
15.03.2024 09:46:35
hary
Moin 
Application.Goto Reference:=Columns(21), scroll:=True

Die 21 musst du anpassen. Es ist die Spaltennummer.
gruss hary
Damit man nicht an Fingern abzählen muss …
15.03.2024 10:06:01
RPP63
Moin Hary!
Nur als Hinweis:
Columns() verträgt durchaus die Spaltenbeschriftung als String. 
Application.Goto Reference:=Columns("NM"), Scroll:=True


Gruß Ralf
AW: Damit man nicht an Fingern abzählen muss …
15.03.2024 14:23:48
BlackForestPhoto
Super Danke an alle für die schnelle Hilfe,
beide Formeln funktionieren.

Gruß
Helmut
Aber: Warum VBA?
15.03.2024 14:49:45
RPP63
Ergänzend:
Man kann natürlich auch (im fixierten Bereich) einfach eine Formel eingeben:
=HYPERLINK("#NM1";"hüpf mal")
Anzeige

Links zu Excel-Dialogen

Frame

Beliebteste Forumthreads (12 Monate)

Anzeige
Jetzt das Excel-Portal bewerten: Deine Stimme zählt!

Beliebteste Forumthreads (12 Monate)

Anzeige
Anzeige
Anzeige